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?