Is it possible to find out if a user is locking a particular record from a Forms 5 environment?

Hi,

I am trying to pre-emp 2 users trying to update the same record at once. (The users don't like the Forms 5 inbuilt message that appears when oracle cannot lock the record for update!!) and the only way that I can achieve this with minimum fuss is I think to check to see if a particular record is being locked by another user prior to allowing a user into that record.

I know you can run a query to find out if a table is locked, but can you narrow it down to specific record(s).

Alternatively, does anyone know how to trap the inbuilt error message that you get when editing a record that is locked by someone else - It has no error number. Or is there any other way to achieve my goal.

Thanks in advance

Claire Received on Fri Aug 06 1999 - 05:21:38 CDT