General information
Category:
Coding, syntax & commands
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only