Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Begin Transaction ....
Message
 
À
28/06/2002 07:35:19
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00673158
Message ID:
00673230
Vues:
15
>Carmen,
>
>1) You *must* use table buffering;
>2) You *must* use TABLEUPDATE()s on each of your tables;

Jim,

The above is not correct. It is not necessary to use buffering for transactions, it is necessary that the tables involved reside in a VFP database.

I would also advise that with two different databases that each one have its own transaction, so that the psuedo code would be;
BEGIN TRANSACTION
   Post to database A
   IF No Error
     BEGIN TRANSACTION
       Post to database B
       IF No Error
         * End 2nd txn
         ENDTRANSACTION
         * End 1st Txn
         ENDTRANSACTION
       ELSE
         * Rollback 2nd txn
         ROLLBACK
         * Rollback 1st Txn
         ROLLBACK
       ENDIF
   ELSE
     * Rollback 1st txn
     ROLLBACK
  ENDIF
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform