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:
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.
Prepared statements feature is used during the call for performance reason if it's possible.