I'm using forms 6i and I build tabular form that many users will use it, so I need when user select record another users can't select that record.
User X selects record.
When users Y try to select that record we can display message to inform the user Y by that record selected by another user
thank you for your quick reply you are right but my problem exactly is i have master block build on view then detail block build on another view then detail block build on table that users can edit it so i need when user select record in the first master block another user can’t select the same record.
So, when the user does the "selection", try to lock the record manually with code like
FOR UPDATE OF ID NOWAIT;
If that works, the selction was successful and the record is locked. If that throws an exception, another user already had selected the record.
Be aware that there is no way to explicitly unlock a record. You will need to issue a COMMIT or a ROLLBACK to do so.