Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
TRANSACTION Question
Message
From
05/10/2001 16:21:24
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00564854
Message ID:
00564992
Views:
11
I tried your example with free tables and It didn't work in VFP 7 even 6.0
Also I didn't receive an error and the table didn't rollback. However it works perfectly when I use Tables in database. Roberto

>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?
Previous
Reply
Map
View

Click here to load this message in the networking platform