SQL_EXEC_DIRECT action

The action executes an SQL command.

SQL_EXEC_DIRECT handleIdent_Int, retCodeIdent_Int, stringExpr [,nrExecuteLine]

handleIdent_Int	in	Identifier - the unique number (handle) of a connection.
retCodeIdent_Int	out	Return code identifier.
strExpr	in	Expression of Text type.
nrExecuteLine	out	Identifier of Int type - the parameter acquires the value which is equal to the number of modified records in database.

The value of the parameter transHandle_Int. See the table of error codes. It is possible to get extended error information.

The action executes an SQL command on a database that 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.

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.

Work with a database (actions SQL_ ...).

DB_TRANS_OPEN
DB_TRANS_COMMIT
DB_TRANS_ROLLBACK
DB_TRANS_CLOSE

SQL_CONNECT
SQL_DISCONNECT
SQL_EXEC_PROC

SQL_PREPARE
SQL_BINDIN
SQL_FETCH
SQL_FREE

SQL_SELECT

All database related actions.