Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Note
This article contains Visual FoxPro ODBC Driver-specific information. For general information about this function, see the appropriate article under ODBC API Reference.
Support
Full.
ODBC API conformance
Core level.
Remarks
Requests a commit or rollback operation for all active operations on all statement handles (hstmt) 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 can't be inactive.
For more information, see SQLTransact Function in the ODBC Programmer's Reference.