>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