Home » Developer & Programmer » Forms » form generate message frm-40654 (oracle 10g experes edition,form,windows xp)
form generate message frm-40654 [message #521691] Thu, 01 September 2011 02:48 Go to next message
joelsam2003
Messages: 1
Registered: September 2011
Location: KERALA
Junior Member
what is this error.it will come on after save record on table through form.

FRM-40654:Record has been updated by another user.Re-query to see change

Report message to a moderator

Re: form generate message frm-40654 [message #521696 is a reply to message #521691] Thu, 01 September 2011 03:41 Go to previous messageGo to next message
cookiemonster
Messages: 13926
Registered: September 2008
Location: Rainy Manchester
Senior Member
It means that the values the form thinks are in the record on the DB aren't the same as what is actually on the DB.
While the message says it's due to another user it's more commonly due to a design flaw in the code. There are several ways to get in this situation.
One is to use an update statement against the record the form has just updated.
You need to find out at what point the record is getting changed.

Report message to a moderator

Re: form generate message frm-40654 [message #521699 is a reply to message #521696] Thu, 01 September 2011 04:06 Go to previous message
cookiemonster
Messages: 13926
Registered: September 2008
Location: Rainy Manchester
Senior Member
Actually the most common cause of this error is DB triggers on the table changing values. If you've got any then you need to set the blocks DML Return property to Yes.

Report message to a moderator

Previous Topic: Client_To_AS - Is there a file size limit?
Next Topic: PLSQL_TABLE.POPULATE_TABLE fails finding data
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jul 26 06:03:00 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.