Bde.DBTables.TUpdateSQL.ExecSQL
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.