| workaround for locking due to multiple user [message #217798] |
Mon, 05 February 2007 10:14  |
yogen
Messages: 39
Registered: October 2006
Location: UK
|
Member |
|
|
Hi All,
We are currently facing a problem that there are multiple users who are updating same table through same oracle form (on diffrent work stations).
Is it possible to give a friendly message to the user if the record is already locked by another user?
e.g. if i use when-new-record-instance trigger and some how check in database current status of the new reocrd (locked /unlocked) and if unlocked put an error message.?
but i am not sure how do i check for the current record's status?
please help me.
Many thanks in advance,
yogendra.
|
|
|
|
|
|
| Re: workaround for locking due to multiple user [message #218045 is a reply to message #217967] |
Tue, 06 February 2007 09:48  |
yogen
Messages: 39
Registered: October 2006
Location: UK
|
Member |
|
|
"Could not reserve record (2 tries), keep trying?”
this is the message user is getting when he presses save button after changing the existing record.
but i want to capture record locking status once user navigates to the record.
thanks for your interest.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
