4D Doc Center : ODBC_SQLExecDirect

Home

4D v14.1

ODBC_SQLExecDirect


ODBC_SQLExecDirect ( stmtID ; stmtText ) -> Function result

Parameter	Type	Description
stmtID	Longint	Statement ID
stmtText	Text	SQL statement to be executed
Function result	Longint	Returns the result of the MS ODBC API function SQLExecDirect

Description

The ODBC_SQLExecDirect command executes a preparable statement, using the current values of the parameter marker variables if any parameters exist in the statement.

stmtID is a valid statement ID returned by ODBC_SQLAllocStmt.

stmtText is an SQL statement to be executed.

For more information, please see the SQLExecDirect function in the MS ODBC API Reference at http://msdn.microsoft.com/en-us/library/ms713611(VS.85).aspx.

Function Results

SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_NEED_DATA, SQL_STILL_EXECUTING, SQL_ERROR, SQL_NO_DATA, or SQL_INVALID_HANDLE.

Example

See the example for the ODBC_SQLGetCursorName command.