4D Doc Center : ODBC

Home

4D v14.1

ODBC_SQLPrepare


ODBC_SQLPrepare ( stmtID ; statementText ) -> Function result

Parameter	Type	Description
stmtID	Longint	Statement ID
statementText	Text	SQL text string
Function result	Longint	Returns the result of the MS ODBC API function SQLPrepare

The ODBC_SQLPrepare command prepares a SQL string for execution passed in statementText.

stmtID is a valid statement ID returned by ODBC_SQLAllocStmt.

statementText is the SQL text string to be executed later with ODBC_SQLExecute.

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

SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_STILL_EXECUTING, SQL_ERROR, or SQL_INVALID_HANDLE.

See the example for the ODBC_SQLFetch command.