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.
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.