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

From: Claire Moore <claire.moore_at_capgemini.co.uk>
Date: Fri, 06 Aug 1999 11:21:38 +0100
Message-ID: <37AAB732.F0C_at_capgemini.co.uk>



Hi,

[Quoted] [Quoted] I am trying to pre-emp 2 users trying to update the same record at once. [Quoted] (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 [Quoted] 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 [Quoted] 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 [Quoted] has no error number. Or is there any other way to achieve my goal.

Thanks in advance

Claire Received on Fri Aug 06 1999 - 12:21:38 CEST

Original text of this message