Executes a specified type of SQL statement to perform an update for an otherwise read-only
results set when cached updates is enabled.
Syntax:
procedure ExecSQL(UpdateKind: TUpdateKind);
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.
 | To both bind parameters and execute a statement, call Apply. |
