Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Understand Transactions
Message
From
08/11/2001 06:49:28
Alexandre Palma
Harms Software, Inc.
Alverca, Portugal
 
 
To
08/11/2001 06:29:02
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00578735
Message ID:
00578949
Views:
13
>>All I have is the CD's so please do not say RTFM.
>>
>>I am trying to understand how to use the BEGIN TRANSTRACTION and END TRANSACTION commands to decrease the likelyhood of entering bad data into tables (i.e. only m of n tables is updated, currupted headers, currupted indexes, power surges, etc). I understand its not a cure all but it way help.
>>
>>Any information and pointers would be appreciated
>
>Transactions are discussed in the online help, which should be on your installation CDs.
>
>I don't know how safe a VFP transaction is for power surges. To avoid data corruption, it helps to issue FLUSH after TableUpdate() (or after REPLACE, in an unbuffered table).
>
>HTH, Hilmar.

Also check the SET AUTOSAVE command.
Alexandre Palma
Senior Application Architect
Previous
Reply
Map
View

Click here to load this message in the networking platform