version 2004
ODBC_SQLExecDirect (stmtID; stmtText) Longint
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 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.