4D v13

ODBC_SQLAllocStmt

Home

 
4D v13
ODBC_SQLAllocStmt

ODBC_SQLAllocStmt 


 

ODBC_SQLAllocStmt ( connectionID ; stmtID ) -> Function result 
Parameter Type   Description
connectionID  Longint in Connection ID
stmtID  Longint in Statement ID
Function result  Longint in Returns the result of the MS ODBC API function SQLAllocHandle

The ODBC_SQLAllocStmt function allocates a statement handle to connectionID.

connectionID is a valid connection ID returned by ODBC_SQLAllocConnect and a connection must be established using the ODBC_SQLConnect command.

stmtID is the statement ID returned if the connection is valid. It can then be passed to all other commands that require a stmtID, like ODBC_SQLSetStmtAttr and ODBC_SQLExecute.

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

SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_INVALID_HANDLE, or SQL_ERROR.

Example  

The following method connects you to a data source and then creates a statement handle ID:

 $result:=ODBC_SQLAllocConnect($connectionID)
 $result:=ODBC_SQLConnect($connectionID;"access";"Administrator";"admin1")
 $result:=ODBC_SQLAllocStmt($connectionID;$statementID)

 
PROPERTIES 

Product: 4D
Theme: ODBC_Connection
Number: 16995

 
INDEX

Alphabetical list of commands

 
HISTORY 

Created: 4D ODBC Pro 2004