IBX.IBUpdateSQL.TIBUpdateSQL.ExecSQL

• Up to Parent: TIBUpdateSQL

Delphi

procedure ExecSQL(UpdateKind: TUpdateKind);

C++

void __fastcall ExecSQL(Data::Db::TUpdateKind UpdateKind);

Properties

Type	Visibility	Source	Unit	Parent
procedure function	public	IBX.IBUpdateSQL.pas IBX.IBUpdateSQL.hpp	IBX.IBUpdateSQL	TIBUpdateSQL

Description

Executes a specified type of SQL statement to perform an update for an otherwise read-only results set when cached updates is enabled.

Call ExecSQL to execute the SQL statement necessary for updating the records belonging to a read-only result set when cached updates is enabled. UpdateKind specifies the statement to execute, and can be one of the following values:

Value	Meaning
ukModify	Execute the SQL statement used to update records in the dataset
ukInsert	Execute the SQL statement used to insert new records into the dataset
ukDelete	Execute the SQL statement used to delete records in the dataset.

If the statement to execute contains any parameters, an application must call SetParams to bind the parameters before calling ExecSQL. To determine if a statement contains parameters, examine the appropriate ModifySQL, InsertSQL, or DeleteSQL property, depending on the statement type intended for execution.

Note: To both bind parameters and execute a statement, call Apply.