Specifies the SQL UPDATE statement to use when applying an update to a record is enabled.
Set ModifySQL to the SQL UPDATE statement to use when applying an updated record to a dataset. Statements can be parameterized queries. To create a UPDATE statement at design time, use the UpdateSQL editor to create statements, such as:
At run time, an application can write a statement directly to this property to set or change the UPDATE statement.
As the example illustrates, ModifySQL supports an extension to normal parameter binding. To retrieve the value of a field as it exists prior to application of an update, the field name with 'OLD_'. This is especially useful when doing field comparisons in the WHERE clause of the statement.