General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
BEGIN/END Transaction
Hi all,
I have a process which spans over 3 databases (Job Cost, AP, GL). I have tables open in the DE from all 3 DB's. The process must keep the integrity of all the tables modified in all 3 DB's.
My question is, do I need to issue 3 Begin Transaction commands (before each process of the appropriate DB) and 3 End Transaction / Rollback, or I need only one at the begining of the process and one at the end.
I am using VFP 7.
TIA,
Shlomo
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only