Updated: 2018-05-04

OLE DB Property of Rowset and Command — «delete_sql»

Name:
delete_sql
Type:
VT_BSTR
R/W:
R/W
Default:
EMPTY
IBProvider:
2, 3, 5

Defines SQL queries executed when deleting row.

Several SQL are enumerated through the semicolon.

The use only of «OLD» parameters is allowed in the query text.

Example

delete_sql = «DELETE FROM MY_TABLE WHERE ID=:OLD.ID»

See also

Other properties of group

Other sets of properties