4D v14.1

ODBC_SQLAllocStmt

Home

 
4D v14.1
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

 
HISTORY 

Created: 4D ODBC Pro 2004

 
ARTICLE USAGE

4D ODBC Pro ( 4D ODBC Pro v11.4)
4D ODBC Pro ( 4D ODBC Pro v12)
4D ODBC Pro ( 4D v13)
4D ODBC Pro ( 4D v14 R3)
4D ODBC Pro ( 4D v14.1)
4D ODBC Pro ( 4D v14 R2)
4D ODBC Pro ( 4D v14 R4)