4D v13

ODBC_SQLPrepare

Home

 
4D v13
ODBC_SQLPrepare

ODBC_SQLPrepare 


 

ODBC_SQLPrepare ( stmtID ; statementText ) -> Function result 
Parameter Type   Description
stmtID  Longint in Statement ID
statementText  Text in SQL text string
Function result  Longint in 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.

Example  

See the example for the ODBC_SQLFetch command.

 
PROPERTIES 

Product: 4D
Theme: ODBC_Prepare requests
Number: 16975

 
INDEX

Alphabetical list of commands

 
HISTORY 

Created: 4D ODBC Pro 2004

 
SEE ALSO 

ODBC_SQLExecute
ODBC_SQLFetch