Record locking problem

I have recently began having a problem in an application using Forms 4.5. A user attempts to edit a record and upon changing a field, receives the message "Could not reserve record(2) tries. Keep trying?" and then the message "FRM-40501 " etc.

I know this is an indication that the record is locked by another user however the other user is the same one trying to update the record. No one else is modifying that record. If you exit the application usually when you go back in you can modify the record. The users have been using this application for a couple of years with no problems so I don't believe it is a user problem.

At about the time this problem arose, a couple of new columns were added to the table and the application was modified to reflect the new fields.

I initally also had pre-update trigger in the app to insert the username of the user making the modification into a field in the table and thought that was causing the problem but it still exists after removing the trigger.

The database is 7.3.3 (yes I know I need to update and will be soon) but I need to know if the problem will follow the upgrade to 8i and if so how to fix it. One thing I have thought of is to export and re-import the table since I added the new fields to the end of table.

Any suggestions would be appreaciated.

Thanks
Willis Newton Received on Wed May 02 2001 - 13:05:25 CDT