ISQLPerformer.Execute Method
Executes a SQL DML statement (INSERT, UPDATE, or DELETE) and returns the number of affected rows.
Syntax
Unit: Aurelius.Sql.Interfaces
function ISQLPerformer.Execute(SQL: string; Params: TList<TDBParam>; BatchSize: Integer): Integer; virtual; abstract;Parameters
| <-> | Parameter | Type | Description |
|---|---|---|---|
| SQL | string | The SQL statement to execute. | |
| Params | TList<TDBParam> | The list of bound parameter values for the statement. | |
| BatchSize | Integer | When 1, the statement is executed once as a normal single-row DML call.When greater than 1, the statement is executed as an array DML (batch) operation over that many rows; each parameter in Params must supply one value per row via its ParamValues array. If the underlying driver supports batch execution (IDBBatchConnection), it is used directly; otherwise the rows are executed individually in a loop. |
Returns
The number of rows affected by the statement.