DbServer.Replace Method (Typed) |  |
Replace one or several fields with a new expression, for all records that match a specified scope.
Namespace: XSharp.VO.SDK
Assembly: XSharp.VORDDClasses (in XSharp.VORDDClasses.dll) Version: 2.19
SyntaxVIRTUAL METHOD Replace( acbExpression, aFieldList, cbForBlock, cbWhileBlock, uScope ) AS LOGIC CLIPPER
Parameters
- 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: LogicTRUE 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.
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:
X#
1// Add 100 to the salaries of female employees 2oDBEmp:Replace({||Salary+100}, #Salary, {||Sex="F"}) 3// Subtract 20 from grade, assign a raise of 100, 4// and establish a new raise date for those 5// employees that are newly assigned to Proj20 6oDBEmp:Replace({"GRADE-20", "100", "NewDate"}, {#Grade, #Raise, #RaiseDate}, ; 7{|| NewAssignment(EmpNo) = Proj20}) 8// Assign 0 to the credit status field of all records 9oDBEmp:Replace(0,#CreditStatus)
See Also