|
|
|
|
|
|
|
|
|
version 2004
ODBC_SQLAllocStmt (connectionID; stmtID) 
Longint
| 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 at http://msdn.microsoft.com/library/en-us/odbc/htm/odbcsqlallocstmt.asp.
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)
|
|
|
|
|
|
|
|
|