Icon DeleteSQL Property

property DeleteSQL: TStrings

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