| [Overview][Constants][Types][Classes][Procedures and functions][Variables][Index] |
Statement to be used when inserting a new row in the database
Source position: sqldb.pp line 660
published property TSQLQuery.DeleteSQL : TStringList; |
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 insert can be specified here.
The SQL statement should be parametrized according to the conventions for specifying parameters. Note that old field values can be specified as :OLD_FIELDNAME
|
The SQL statement to execute |
|
|
Statement to be used when updating an existing row in the database |
|
|
Statement to be used when inserting a new row in the database |
|
|
How to create update SQL statements. |
|
|
Using parameters |
|
|
Automatic generation of update SQL statements |