DbServer.Replace Method | |
Replace one or several fields with a new expression, for all records that match a specified scope.
Namespace:
VO
Assembly:
VORDDClasses (in VORDDClasses.dll) Version: 2.19
Syntax VIRTUAL METHOD Replace(
acbExpression,
aFieldList,
cbForBlock,
cbWhileBlock,
uScope
) AS USUAL CLIPPER
[ClipperCallingConventionAttribute(new string[] { ... })]
public virtual Usual Replace(
Usual acbExpression = default,
Usual aFieldList = default,
Usual cbForBlock = default,
Usual cbWhileBlock = default,
Usual uScope = default
)
Request Example
View SourceParameters
- acbExpression (Optional)
- Type: Usual
The single expression to be evaluated to yield the replacement value or the array of expressions to be evaluated to yield the replacement values. - aFieldList (Optional)
- Type: Usual
An array of fields from the source file that are to be included. The default is all fields. - cbForBlock (Optional)
- Type: Usual
The condition evaluated for each record in the scope; if TRUE, the record is included in the processing. It provides the same functionality as the FOR clause of record processing commands. - cbWhileBlock (Optional)
- Type: Usual
The condition evaluated for each record from the first record until the condition returns FALSE. It provides the same functionality as the WHILE clause of record processing commands. - uScope (Optional)
- Type: Usual
The range of records to process, providing the same functionality as the ALL, REST and NEXT clauses of record processing commands.
Value | Description |
---|
DBSCOPEALL | The scope is all the records in the table. This is the default, although if a WHILE condition is specified, the scope becomes DBSCOPEREST. |
DBSCOPEREST | The scope is the remaining records in the table from the current position. |
<nRecords> |
The scope is the next nRecords records.
|
Return Value
Type:
Usual
TRUE if successful; otherwise, FALSE (although some records still might have been processed).
Remarks
If the specified scope is active, DBServer:Replace() sends a NotifyIntentToMove message before the operation.
It also sends a NotifyFileChange message upon completion, whether successful or not.
If no scope is used, on successful completion, the current record will be the last file record and DBServer:EOF will be TRUE.
Examples
The following examples demonstrate how the DBServer:Replace() method can be used:
1
2oDBEmp:Replace({||Salary+100}, #Salary, {||Sex="F"})
3
4
5
6oDBEmp:Replace({"GRADE-20", "100", "NewDate"}, {#Grade, #Raise, #RaiseDate}, ;
7{|| NewAssignment(EmpNo) = Proj20})
8
9oDBEmp:Replace(0,#CreditStatus)
See Also