Property DeleteSQL: string

Description

SQL statement to be executed when a record from the result set of the query is deleted, using the Delete function. The statement may contain "hard" values or references to fields from the active record. References to field values before the statement is executed should carry the prefix :OLD_. This occurs especially in the WHERE section of the statement.

Example

DELETE FROM T_Language WHERE LangCode =: OLD_LangCode.

This deletes the active record from the result set and also from the database when the ApplyUpdates functions are used.