Skip to content

TSQLQuery.DeleteSQL

Statement to be used when deleting a new row in the database.

Declaration

Source position: sqldb.pp line 739

published property DeleteSQL;

Description

DeleteSQL can be used to specify an SQL DELETE statement, which is used when an existing record was deleted from the dataset, and the changes must be written to the database. TSQLQuery can generate a delete statement by itself for many cases, but in case it fails, the statement to be used for the delete operation can be specified here.

The SQL statement should be parameterized according to the conventions for specifying parameters. Note that old field values can be specified as :OLD_FIELDNAME

See also

Name Description
TSQLQuery.SQL The SQL statement to execute.
TSQLQuery.UpdateSQL Statement to be used when updating an existing row in the database.
TSQLQuery.DeleteSQL Statement to be used when deleting a new row in the database.
TSQLQuery.UpdateMode How to create update SQL statements.
UsingParams Using parameters.
UpdateSQLS Automatic generation of update SQL statements.