How to: Use Automatic Transaction Mode
By default, Visual FoxPro automatically wraps every data-writing operation sent to the remote server in a transaction. This default automatic transaction handling is provided when the Transactions property is set to 1, or DB_TRANSAUTO.
To use automatic transaction mode
Use the DBSETPROP( ) Function to set the Transactions property on the connection to 1 or DB_TRANSAUTO.
-or-
Use the SQLSETPROP( ) Function to set the Transactions property on the active connection to 1 or DB_TRANSAUTO.
Transaction processing for the remote table is automatically handled.
Note
The Visual FoxPro commands BEGIN TRANSACTION and END TRANSACTION create a transaction for the local Visual FoxPro cursor only. They don't extend the transaction to the remote server.
See Also
Tasks
How to: Control Transactions Manually
Concepts
Managing Connections with SQL Pass-Through
Other Resources
Using SQL Pass-Through Technology
Enhancing Applications Using SQL Pass-Through Technology
Planning Client/Server Applications