Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Data Transaction??
Message
From
21/06/2005 22:03:06
 
 
To
21/06/2005 21:50:59
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01025330
Message ID:
01025331
Views:
16
Hi,
With tabled buffered
* Make your data changes here

llOK = .T.

BEGIN TRANSACTION

IF llOK AND NOT TABLEUPDATE(.T., .F., 'Table1')
   llOK = .F.
ENDIF

IF llOK AND NOT TABLEUPDATE(.T., .F., 'Table2')
   llOK = .F.
ENDIF

IF llOK AND NOT TABLEUPDATE(.T., .F., 'Table3')
   llOK = .F.
ENDIF

IF llOK
   END TRANSACTION
   FLUSH               && FLUSH FORCE for VFP9
ELSE
   ROLLBACK

   TABLEREVERT(.T., 'Table1')
   TABLEREVERT(.T., 'Table2')
   TABLEREVERT(.T., 'Table3')
ENDIF
HTH
I am not the most powerful man in this world.
I am not the worst man in this world either.
I just as same as all of you.
I still need to learn from my mistakes...
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform