Hello all,

I need some assistance with update logic. Currently I have a VFP6 application connecting to an Oracle 8 database. All view are created through SPT and I then use CURSORSETPROP to make the views updatable.

The problem that I am running into is that since this is a relational database multiple records in multiple tables must be updated at once. I am unable to force updates with TableUpdate due to business rules.

So here is my question. Is there some way that I can check each of the tables to see if any user has made an update to the table since I grabbed my view without having to do a second select and do a field by field comparison? I know table update generates an error if this happens but if I update half of the tables and then encounter an error I cannot undo the updates that I just made.

Any suggestions would be extremely welcome.
Thank you
Matt