IBX.IBUpdateSQL.TIBUpdateSQL.InsertSQL

• Up to Parent: TIBUpdateSQL

Delphi

property InsertSQL: TStrings index 1 read GetSQLIndex write SetSQLIndex;

C++

__property System::Classes::TStrings* InsertSQL = {read=GetSQLIndex, write=SetSQLIndex, index=1};

Properties

Type	Visibility	Source	Unit	Parent
property	published	IBX.IBUpdateSQL.pas IBX.IBUpdateSQL.hpp	IBX.IBUpdateSQL	TIBUpdateSQL

Description

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

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
(Country, Currency)
values (:Country, :Currency)

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