TSQLQuery.InsertSQL property
Statement to be used when inserting a new row in the database.
Declaration
property InsertSQL:;Description
InsertSQL can be used to specify an SQL
INSERT
statement, which is used when a new record was appended to the dataset,
and the changes must be written to the database.
TSQLQuery
can generate an insert 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 parameterized according to the conventions
for specifying parameters. Note that old field values can be specified
as :OLD_FIELDNAME
See also
An experiment, built from development snapshots. Not the official Free Pascal or Lazarus documentation.