Home » Developer & Programmer » Forms » LOCKING PROBLEM IN DEVELOPER 2000 APPLICATION
LOCKING PROBLEM IN DEVELOPER 2000 APPLICATION [message #82580] Tue, 10 June 2003 22:29 Go to next message
Padmalaya Nanda
Messages: 7
Registered: June 2003
Junior Member
I've an application developed using developer 2000. The appl. needs to be accessed
by multiple users, as there is a post-query trigger on one block(having multiple records)
, which assigns some value to one of the items of the block, so the records are locked.
So whne the second user accesses the application, he gets
"FRM-40501:Oracle error:Unable to reserve record for update or delete" error for
each record of the block. How can I make the block read only when the second user
accesses the application, which trigger i should use, if the trigger is on-lock,
then what should I write in that trigger. Pls. reply asap, it's very very urgent.

Report message to a moderator

Re: LOCKING PROBLEM IN DEVELOPER 2000 APPLICATION [message #82584 is a reply to message #82580] Wed, 11 June 2003 00:55 Go to previous message
Shehryar Qureshi
Messages: 7
Registered: November 2002
Junior Member
No Problem:
Just go to the property of database block .
Change the property of 'Locking Mode' to Manual.

Report message to a moderator

Previous Topic: Its Urgent About Execute_Query?
Next Topic: What trigger fires where we change a text item
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 12:27:46 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.