Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Understand Transactions
Message
De
07/11/2001 16:10:08
 
 
À
07/11/2001 16:02:09
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00578735
Message ID:
00578741
Vues:
21
All the documentation is online at http://msdn.microsoft.com/library/?url=/library/en-us/fox7help/html/vfp7startpage.asp?frame=true

Basically 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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform