4D Doc Center : ODBC

4D v13

ODBC_SQLAllocStmt


ODBC_SQLAllocStmt ( connectionID ; stmtID ) -> Function result

Parameter	Type	Description
connectionID	Longint	Connection ID
stmtID	Longint	Statement ID
Function result	Longint	Returns the result of the MS ODBC API function SQLAllocHandle

Description

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.

Function Results

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)