Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
TRANSACTION Question
Message
From
05/10/2001 12:17:58
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00564854
Message ID:
00564865
Views:
16
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform