I have a 2.6 table that I need to be able to revert. What I have done is create an updateable view to the 2.6 (tod). I tried to test it with the following code:

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