EPUB | CHM | PDF

TPSQLUpdateSQL.Properties.InsertSQL

Top Previous Next

Specifies the SQL INSERT statement to use when applying a insertion of a record.

Syntax:

property InsertSQL: TStrings;

Description:

Set InsertSQL to the SQL INSERT statement to use when applying an insertion to a dataset. Statements can be parameterized queries. To create a INSERT statement at design time, use the UpdateSQL editor to create statements, such as:

INSERT INTO "Country"  (Name, Capital, Continent)
  VALUES (:Name, :Capital, :Continent)

At run time, an application can write a statement directly to this property to set or change the INSERT statement.

InsertSQL doesn't support an extension to normal parameter binding.