Icon ModifySQL Property

__property System::Classes::TStrings* ModifySQL

Use the ModifySQL property to specify the UPDATE statement to use when applying an update to a source table. Use parameters with the same names as any column names in the source table for any SET operations or WHERE clause conditions, and use the prefix "OLD_" on any parameter names where you want an original column value to be used instead of the current column value being used for the update.
Image