[Overview][Constants][Types][Classes][Procedures and functions][Variables][Index] Reference for unit 'sqldb' (#fcl)

TSQLQuery.InsertSQL

Statement to be used when inserting a new row in the database

Declaration

Source position: sqldb.pp line 658

published property TSQLQuery.InsertSQL : TStringList;

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 parametrized according to the conventions for specifying parameters. Note that old field values can be specified as :OLD_FIELDNAME

See also

TSQLQuery.SQL

  

The SQL statement to execute

TSQLQuery.UpdateSQL

  

Statement to be used when updating an existing row in the database

TSQLQuery.DeleteSQL

  

Statement to be used when inserting a new row in the database

TSQLQuery.UpdateMode

  

How to create update SQL statements.

UsingParams

  

Using parameters

UpdateSQLS

  

Automatic generation of update SQL statements


Documentation generated on: Sep 28 2017