Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to Emulate Begin - End Trans
Message
From
22/11/2006 12:31:07
 
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01171838
Message ID:
01171846
Views:
7
VFP9 supports transactions for free tables.

>
>I've got these tables that belong to a FPD2.6 application. I'm gradually replacing the FPD system with a new Windows version. Of course, the tables are all by default free, there being no dbcs before VFP.
>
>Now, there is a critical bit of code where I create up to 4 recs at a time, all assoc. with each other, but I may also have to first delete up to 4 recs and replace them with these. Ideal candidate for transactioms. But, I assume I can't include these tables in a VFP dbc for fear of "future-tainting" them for the FPD app.
>
>Any ideas on how to create a "critical code" section equive. to a begin ... end trans bracket?
>
>Sure, I guess I'll have to do it with temp tables but there's STILL that problem when these have to overwrite the live data.
>
>'ppreciate it
>
>Terry
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform