>>I have a form used for user modifications into three tables. A master table, and two child tables. The master is buffered OPT 3, and one child table is OPT 3, and the other OPT 5. When I encounter an update conflict for the child table that is OPT 3, and issue a tablerevert(), I get an update conflict error. When I get an update conflict with the other tables and issue a tablerevert(), it works fine! The tableupdates are rapped up in a simple non-nested transaction. When I encounter a update conflict error and I decide to tablerevert(), I ROLLBACK and then issue tablerevert() for all of the tables in a looping construct. Is there a reason why one table would be giving me this error during a tablerevert(). I've tried everything I know to get this to work, but no can do. everything else works okay in this procedure except when trying to tablerevert() the one child table. When I put a watch on curval/ oldval for the field that was changed in this table the watch window reports
>>"expression could not be evaluated" but if I click on message it very briefly displays the oldval/curval values and then displays the "expression could not be evaluated message again. Has anyone experienced this before, or have any ideas of what might be going on here??? Sorry for the lengthy message.
>>
>>Thanks
>>
>>John
>
>John,
>
>This is just curiousity here, but do you have defined relations between these tables? If so, try deleting them and try it. I've removed all of my relations although I used to use them. I remember running into this....but since I don't use relations anymore, I'm trying to remember if this was what caused it as I haven't run into this in a long time.
>
>Steve

Hi Steve,

You nailed it! If I remove relationships before I BEGIN TRANSACTION all works well.

I'm curious about something though. Do you remove your relationships before your transaction begins or do you use relationships at all?

Thanks for taking time to help me with this.

John.