OraFAQ Forum: Forms » FRM-40654 occurs on second update

Home » Developer & Programmer » Forms » FRM-40654 occurs on second update

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

FRM-40654 occurs on second update [message #139540]

Wed, 28 September 2005 10:25

kirchoff
Messages: 7
Registered: June 2005
Location: Wichita

Junior Member

All,

This is a tricky one. I've already looked over every post dealing with FRM-40654 and applied all those changes.

When you go into my form and update a field and commit it it works just fine. However, the second time you make a change and commit it you get the FRM-40654 error....twice!!

Has anyone seen this type of situation before.

Thanks,

Alan

Report message to a moderator

Re: FRM-40654 occurs on second update [message #139546 is a reply to message #139540]

Wed, 28 September 2005 10:48

Kavitha Suresh
Messages: 22
Registered: September 2005

Junior Member

Doc ID: Note:1003629.6
Subject: Troubleshooting FRM-40654
Type: PROBLEM
Status: PUBLISHED
Content Type: TEXT/X-HTML
Creation Date: 08-APR-1994
Last Revision Date: 16-SEP-2004

[MOD-EDIT]MetaLink content removed

Hope this helps ....
If you have Metalink access then you can check it out ...

[MOD-EDIT]
Read the metalink terms of agreement. These notes cannot be distributed on third party websites like OraFAQ. Sorry, MHE

[Updated on: Fri, 30 September 2005 04:30] by Moderator

Report message to a moderator

Re: FRM-40654 occurs on second update [message #139583 is a reply to message #139540]

Wed, 28 September 2005 13:54

kiran
Messages: 503
Registered: July 2000

Senior Member

First time seeing such a lengthy post Smile

Thanks.........

--Kiran.

Report message to a moderator

Re: FRM-40654 occurs on second update [message #139584 is a reply to message #139583]

Wed, 28 September 2005 13:57

kirchoff
Messages: 7
Registered: June 2005
Location: Wichita

Junior Member

Just to let everyone know.....

I found the problem.

It turned out in a PRE-UPDATE trigger there were a couple statements updating a couple of fields from totally different block.

It was staring at me all the time. I saw that and hit my head.....duh!!

Thanks to all who replied.

Thanks,
Alan

Report message to a moderator

Re: FRM-40654 occurs on second update [message #139630 is a reply to message #139584]

Wed, 28 September 2005 19:11

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

We ALL have moments like this. Don't worry, it's only our subconscious mind teaching our conscious mind to program.

David

Report message to a moderator

Previous Topic:	Forms login help
Next Topic:	ORDER bye clause

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 01 14:32:35 CST 2025