SQL_EXEC_DIRECT
SQL_EXEC_DIRECT action
Function
The action executes an SQL command.
Declaration
SQL_EXEC_DIRECT handleIdent_Int, retCodeIdent_Int, stringExpr [,nrExecuteLine]Parameters
handleIdent_Int | in | Identifier - the unique number (handle) of a connection. |
retCodeIdent_Int | out | Return code identifier. |
strExpr | in | Expression of the Text type. |
nrExecuteLine | out | Identifier of the Int type - the parameter acquires the value which is equal to the number of modified records in a database. |
Return code
The value of the parameter transHandle_Int. See the table of error codes. It is possible to get extended error information.
Description
The action executes an SQL command on a database which is opened using the action SQL_CONNECT. The command is represented by a value of the expression stringExpr.
The nrExecuteLine parameter acquires the value which is equal to the number of modified records in database by SQL commands INSERT, UPDATE, DELETE.
Note
The action SQL_PREPARE, SQL_FETCH, SQL_FREE are intended to read a database using the SQL command SELECT.
If a parameterization of SQL command is required, it is possible to use the action SQL_EXEC_PROC.
Related pages: