TTdbDataSet.Replace
TTdbDataSet
Top 


Replaces field values in a range of rows.

procedure Replace(const Filter, Fields, Expressions: string): LongInt;

Description
Replace sets the values of the Fields to the values calculated by Expressions for all records that meet the Filter's condition. The Expressions are evaluated in the context of each record.

Example
The following example appends the digit nine to all phone numbers from Reading, GB:
Replace('Phone like "+44 118*", 'Phone', 'Phone + "9"');