>SELECT 0
>USE c:\temp\tes1 && 5.0 table
>
>SELECT 0
>USE c:\temp\tod && 2.6 table
>
>SELECT 0
>USE test!TimeOfDay && updatable view to 2.6 table
>CURSORSETPROP("buffer", 5, "TimeOfDay")
>
>INSERT INTO test1(dnis) VALUES("Test")
>INSERT INTO timeofday(dnis) VALUES("Test")
>
>BEGIN TRANSACTION
> TABLEUPDATE(1, .T., "test1")
> TABLEUPDATE(1, .T., "timeofday")
>ROLLBACK
>
>test1 rolls back the changes but timeofday does not roll back the changes to tod. Why is this?
>
>Ed
Ed,
That is because the TableUpdate() on the view succeeded and that in turn updated the free table, the free table cannot particiate in the transaction so its update is not buffered inside of the transaction. When you issue the rollback you are rolling back all of the actions that are part of the transaction adn the free table update is not part of the transaction.