Bde.DBTables.TUpdateSQL.ExecSQL

• Up to Parent: TUpdateSQL

Delphi

procedure ExecSQL(UpdateKind: TUpdateKind); virtual;

C++

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

Properties

Type	Visibility	Source	Unit	Parent
procedure function	public	Bde.DBTables.pas Bde.DBTables.hpp	Bde.DBTables	TUpdateSQL

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
ukDelete	Execute the SQL statement used to delete records in the dataset (DeleteSQL).
ukInsert	Execute the SQL statement used to insert new records into the dataset (InsertSQL).
ukModify	Execute the SQL statement used to update records in the dataset (ModifySQL).

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.

See Also

• Apply

• DeleteSQL

• InsertSQL

• ModifySQL

• SetParams

• Using Multiple Update Objects