Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Checking for uncommited transactions
On Fri, 07 Mar 2003, flavio_at_tin.it wrote:
>
>> Or.. much simple and safer.. you simply rollback all data controls in >> the form's destructor. After all, the user did cancel the form >> without
>> to save the changes he made to the database.
If you lock the row with select for update (meaning, no other user can update it once its being worked on, then a changed date maintained by a trigger could be used. Your selected changed date known by the client, if different than the existing changed date would tell you that a particular row has been modified.
-- Galen deForest Boyer Sweet dreams and flying machines in pieces on the ground.Received on Mon Mar 10 2003 - 20:38:05 CST