EPUB | CHM | PDF

TPSQLUpdateSQL.Properties.DeleteSQL

Top Previous Next

Specifies the SQL DELETE statement to use when applying a deletion of a record.

Syntax:

property DeleteSQL: TStrings;

Description:

Set DeleteSQL to the SQL DELETE statement to use when applying a deletion to a record. Statements can be parameterized queries. To create a DELETE statement at design time, use the UpdateSQL editor to create statements, such as:

DELETE FROM "Country" WHERE Name = :Name

At run time, an application can write a statement directly to this property to set or change the DELETE statement.

DeleteSQL doesn't support an extension to normal parameter binding. It can not retrieve the value of a field as it exists prior to application of an update, the field name with 'OLD_'. This feature may be included in future releases.