[Overview][Constants][Types][Classes][Procedures and functions][Variables][Index] |
Execute a SQL statement.
Source position: db.pas line 1364
function IProviderSupport.PSExecuteStatement( |
const ASQL: string; |
AParams: TParams; |
ResultSet: Pointer = Nil |
):Integer; |
ASQL |
|
SQL statement to execute (may contain parameters) |
AParams |
|
Parameter values to substitute when executing ASQL |
ResultSet |
|
Pointer to resultset (if any) |
True if the statement ASQL was executed succesfully.
PSExecuteStatement will execute the ASQL SQL statement in the current transaction. The SQL statement can have parameters embedded in it (in the form :ParamName), values for these parameters will be taken from AParams. If the SQL statement returns a result-set, then the result set can be returned in ResultSet. The function returns True if the statement was executed succefully.
PSExecuteStatement does not modify the content of CommandText: PSGetCommandText returns the same value before and after a call to PSExecuteStatement.
PSGetCommandText |
PSSetCommandText |
PSExecuteStatement |