4D ODBC Pro v12
ODBC_SQLAllocStmt
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 | |||||
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.
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)
Product: 4D ODBC Pro
Theme: ODBC_Connection
Number:
16995
Created: 4D ODBC Pro 2004
