[Overview][Constants][Types][Classes][Procedures and functions][Variables][Index] |
Execute a SQL statement that does not return a result set
Source position: sqldb.pp line 550
public procedure TCustomSQLQuery.ExecSQL; virtual; |
ExecSQL will execute the statement in TSQLQuery.SQL, preparing the statement if necessary. It cannot be used to get results from the database (such as returned by a SELECT statement): for this, the Open method must be used.
The SQL property should be a single SQL command. To execute multiple SQL statements, use the TSQLScript component instead.
If the statement is a DML statement, the number of deleted/updated/inserted rows can be determined using TCustomSQLQuery.RowsAffected.
The Database and Transaction properties must be assigned before calling ExecSQL. Executing an empty SQL statement is also an error.
If the server reports an error, an exception will be raised.
|
Return the number of rows (records) affected by the last DML/DDL statement |
|
|
Activate the dataset: Fetch data into memory. |