ODBC_SQLExecDirect

4D - Documentation   Français   English   German   4D ODBC PRO, Command Theme List   4D ODBC PRO, Command Alphabetical List   Back   Previous   Next

version 2004


ODBC_SQLExecDirect (stmtID; stmtText) Longint

ParameterTypeDescription
stmtIDLongintStatement ID
stmtTextTextSQL statement to be executed
Function resultLongintReturns 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 at http://msdn.microsoft.com/library/en-us/odbc/htm/odbcsqlexecdirect.asp.

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.

See Also

ODBC_SQLGetCursorName, ODBC_SQLSetCursorName.


4D - Documentation   Français   English   German   4D ODBC PRO, Command Theme List   4D ODBC PRO, Command Alphabetical List   Back   Previous   Next