4D v13

ODBC_SQLExecDirect

Home

 
4D v13
ODBC_SQLExecDirect

ODBC_SQLExecDirect 


 

ODBC_SQLExecDirect ( stmtID ; stmtText ) -> Function result 
Parameter Type   Description
stmtID  Longint in Statement ID
stmtText  Text in SQL statement to be executed
Function result  Longint in Returns the result of the MS ODBC API function SQLExecDirect

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.

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.

 
PROPERTIES 

Product: 4D
Theme: ODBC_Submit requests
Number: 16971

 
INDEX

Alphabetical list of commands

 
HISTORY 

Created: 4D ODBC Pro 2004

 
SEE ALSO 

ODBC_SQLGetCursorName
ODBC_SQLSetCursorName