OraFAQ Forum: Forms » how to suppress the the form error FRM-40654

Home » Developer & Programmer » Forms » how to suppress the the form error FRM-40654

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to suppress the the form error FRM-40654 [message #324166]

Sat, 31 May 2008 03:59

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

Report message to a moderator

Re: how to suppress the the form error FRM-40654 [message #324168 is a reply to message #324166]

Sat, 31 May 2008 04:05

Littlefoot
Messages: 21823
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

Report message to a moderator

Re: how to suppress the the form error FRM-40654 [message #324223 is a reply to message #324166]

Sat, 31 May 2008 13:08

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..

Report message to a moderator

Re: how to suppress the the form error FRM-40654 [message #324612 is a reply to message #324223]

Tue, 03 June 2008 05:46

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

Report message to a moderator

Re: how to suppress the the form error FRM-40654 [message #324614 is a reply to message #324223]

Tue, 03 June 2008 05:48

javed.khan
Messages: 340
Registered: November 2006
Location: Banglore

Senior Member

http://www.orafaq.com/forum/t/30540/0/

Report message to a moderator

Previous Topic:	Retriving Record from Another Table
Next Topic:	New forms developer

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 07:05:09 CST 2025