js editor
Web development
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. |