General information
Category:
Coding, syntax & commands
Title:
Including View inTransaction
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
Next
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