All the documentation is online at
http://msdn.microsoft.com/library/?url=/library/en-us/fox7help/html/vfp7startpage.asp?frame=trueBasically what you want to do is:
1. Make the data changes
2. BEGIN TRANSACTION
3. TABLEUPDATE as required
4. If any TABLEUPDATE fails, do a ROLLBACK. If all are successful, END TRANSACTION
The tables must be in a DBC. Keep the transaction time as short as possible.
>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
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer