Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Understand Transactions
Message
De
08/11/2001 06:29:02
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
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:
00578942
Vues:
9
>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.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform