>>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