MDAC 2.5 SDK - Visual FoxPro ODBC Driver
Support: Full
ODBC API Conformance: Core Level
Requests a commit or rollback operation for all active operations on all statement handles (hstmts) associated with a connection or for all connections associated with the environment handle, henv. SQLTransact works only for data sources that are databases.
If a commit fails when in manual mode, the transaction remains active; you can choose to roll back the transaction or retry the commit operation. If a commit operation fails when in automatic transaction mode, the transaction is rolled back automatically; the transaction cannot be inactive.
For more information, see SQLTransact in the ODBC Programmer's Reference.