Updated: 2023-09-20
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
- The rowset property insert_sql
- The rowset property update_sql
- The rowset property refresh_sql
- The rowset property named_param_prefix