Property ModifySQL: string

Description

SQL statement to be executed when fields of a record in the result set of the query are changed using the FieldValues function. The statement may contain fixed values or references to fields from the active record. References to field values before the statement is executed must contain the prefix :OLD_. This occurs especially in the WHERE section of the statement. For references to fields from the active record, the field name should begin with the : character.

Example

UPDATE T_Language SET Description = :Description WHERE LangCode = :OLD_LangCode