Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to Emulate Begin - End Trans
Message
From
22/11/2006 12:38:33
 
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:
01171850
Views:
6
Yet another reason for converting. I'll have to have a word with my boss ...

>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
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
Previous
Reply
Map
View

Click here to load this message in the networking platform