Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
TRANSACTION Question
Message
De
05/10/2001 12:17:58
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00564854
Message ID:
00564865
Vues:
18
>The VFP7 help for Transactions states:
>
>"Transactions are supported only for tables in a database"
>
>I dont understand this because I know I'v used transactions
>on Free Tables before. The following code works fine:
>
>
>CLOSE ALL
>
>SELECT 0
>USE Table2
>CURSORSETPROP("buffering", 4)
>
>SELECT 0
>USE Table1
>CURSORSETPROP("buffering", 4)
>
>BEGIN TRANSACTION
>
>SELECT table2
>replace IN table2 test2 WITH "HELLO"
>=TABLEUPDATE()
>
>SELECT table1
>replace IN table1 field1 WITH "HELLO"
>=TABLEUPDATE()
>
>END TRANSACTION
>

>
>If I try to do a ROLLBACK, the rollback has no effect. What gives?

I believe you have answered your own question. Since BEGIN TRANSACTION only works for tables in a database, you cannot ROLLBACK a free table.

HTH,
Steve Gibson
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform