Home » Developer & Programmer » Forms » how to suppress the the form error FRM-40654
how to suppress the the form error FRM-40654 [message #324166] Sat, 31 May 2008 03:59 Go to next message
gururajster
Messages: 26
Registered: October 2006
Location: bangalorre
Junior Member

Can anyone tell me how to suppress the error FRM-40654.
I dont want the option of doing execute query.Is there any other option like setting value for :system.message_level in form.

Please help me out.
You suggestion will be appreciated.
Thanks in advance,
Guru
Re: how to suppress the the form error FRM-40654 [message #324168 is a reply to message #324166] Sat, 31 May 2008 04:05 Go to previous messageGo to next message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Oracle
FRM-40654: Record has been updated by another user. Re-query to see change.

Cause:  Another user has updated this record since you performed a query and has changed at least one field in the record. Your actions have not changed the record in memory.

Action:  You can update or delete this record now only if another user has restored the field values back to the way they were when you performed the query. Otherwise, you must re-query to fetch and display the new record into the form before you can update or delete it.

Level:  20
Re: how to suppress the the form error FRM-40654 [message #324223 is a reply to message #324166] Sat, 31 May 2008 13:08 Go to previous messageGo to next message
urnikhil
Messages: 42
Registered: March 2008
Member
I think u can either set value for :system.message_level or use "ON-ERROR" trigger to supress the message.

- Nik..
Re: how to suppress the the form error FRM-40654 [message #324612 is a reply to message #324223] Tue, 03 June 2008 05:46 Go to previous messageGo to next message
athar.fitfd@hotmail.com
Messages: 193
Registered: October 2007
Location: pakistan
Senior Member
Dear

this is a lock that oracle dbms has applied on the record.
that is the record is locked for update as it is updated by another user or any field is updated from the trigger . so, to get rid of the this error, you need to unlock it manually.

write null;

in the ON-LOCK TRIGGER.


I HOPE IT WILL WORK
Re: how to suppress the the form error FRM-40654 [message #324614 is a reply to message #324223] Tue, 03 June 2008 05:48 Go to previous message
javed.khan
Messages: 340
Registered: November 2006
Location: Banglore
Senior Member

http://www.orafaq.com/forum/t/30540/0/
Previous Topic: Retriving Record from Another Table
Next Topic: New forms developer
Goto Forum:
  


Current Time: Tue Dec 06 16:22:06 CST 2016

Total time taken to generate the page: 0.08513 seconds