ODBC_SQLPrepare

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

version 2004


ODBC_SQLPrepare (stmtID; statementText) Longint

ParameterTypeDescription
stmtIDLongintStatement ID
statementTextTextSQL text string
Function resultLongintReturns the result of the MS ODBC API function
SQLPrepare

Description

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 at http://msdn.microsoft.com/library/en-us/odbc/htm/odbcsqlprepare.asp.

Function Results

SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_STILL_EXECUTING, SQL_ERROR, or SQL_INVALID_HANDLE.

Example

See the example for the ODBC_SQLFetch command.

See Also

ODBC_SQLExecute, ODBC_SQLFetch.


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