|
|
|
|
|
|
|
|
|
version 2004
ODBC_SQLEndTran (handleType; handleID; completionType) 
Longint
| Parameter | Type | Description | |
| handleType | Longint | | Type of ID to pass to handleID |
| handleID | Longint | | Either the statement ID or the connection ID |
| completionType | Longint | | Either SQL_COMMIT or SQL_ROLLBACK |
| Function result | Longint |  | Returns the result of the MS ODBC API function |
| SQLEndTran |
Description
The ODBC_SQLEndTran command requests a commit or rollback operation for all active operations on all statements associated with a connection. ODBC_SQLEndTran can also request that a commit or rollback operation be performed for all connections associated with an environment.
If no transactions are active, ODBC_SQLEndTran returns SQL_SUCCESS with no effect on any data sources.
handleType defines which type of ID to pass to handleID and can have one of the following two values:
| Constant | Description |
| SQL_HANDLE_STMT | Statement ID |
| SQL_HANDLE_DBC | Connection ID |
handleID is the connectionID if handleType is equal to SQL_HANDLE_DBC. connectionID is a valid connection ID returned by ODBC_SQLAllocConnect and a connection must be established using the ODBC_SQLConnect command.
Otherwise, handleID is the stmtID, which is a valid statement ID returned by ODBC_SQLAllocStmt.
completionType can have one of the following two values:
| Constant | Description |
| SQL_COMMIT | Commit changes |
| SQL_ROLLBACK | Rollback changes |
For more information, please see the SQLEndTran function in the MS ODBC API at http://msdn.microsoft.com/library/en-us/odbc/htm/odbcsqlendtran.asp.
Function Results
SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_ERROR, or SQL_INVALID_HANDLE.
See Also
ODBC_SQLAllocStmt, ODBC_SQLConnect.
|
|
|
|
|
|
|
|
|