TUpdateSQL.ExecSQL Method

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

Pascal

procedure ExecSQL(UpdateKind: TUpdateKind); virtual;

C++

virtual __fastcall ExecSQL(TUpdateKind UpdateKind);

Description

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.