OraFAQ Forum: Forms » calling form error

Home » Developer & Programmer » Forms » calling form error (oracle forms 10g)

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

calling form error [message #565380]

Tue, 04 September 2012 03:22

furqan
Messages: 115
Registered: January 2012
Location: Hyderabad

Senior Member

Hi all...

iam facing a problem while calling a form.

iam opening a form,inserting data in empty columns of an existing record and with out saving iam calling another form.Inserting and updating data
in the called form and again coming back to old form and then saving the form.

while doing this, when i am trying to save on the called form its giving an error FRM-40403 CALLING FORM HAS UNAPPLIED CHANGES,SAVE NOT ALLOWED.

please help
thanks in advance.

Report message to a moderator

Re: calling form error [message #565428 is a reply to message #565380]

Tue, 04 September 2012 07:03

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Did you try to commit (or, possibly, post - maybe it'll be OK too (I can't tell for sure whether it will be or not, and can't test it myself)) changes you made in the calling form (and then in the called form)?

Report message to a moderator

Re: calling form error [message #565429 is a reply to message #565428]

Tue, 04 September 2012 07:13

furqan
Messages: 115
Registered: January 2012
Location: Hyderabad

Senior Member

after adding post; before call_form has solved the problem of inserting and committing the called form.
but before moving on to called form its showing message FRM-40404:DATABASE APPLY COMPLETE:2 records applied.

when the called form is saved and when the calling form is saved,it is not updating the existing record but inserting new record.

how to avoid this message and insertion of new record..

Report message to a moderator

Re: calling form error [message #565431 is a reply to message #565429]

Tue, 04 September 2012 07:18

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

What's wrong with the message? If you insist, modify :SYSTEM.MESSAGE_LEVEL to a higher value and then restore it after POST.

As of inserting a new record instead of updating it: what kind of a block is it? A data block? Or is it a control block and you perform INSERT / UPDATE / DELETE / SELECT manually?

Report message to a moderator

Re: calling form error [message #565440 is a reply to message #565431]

Tue, 04 September 2012 07:58

furqan
Messages: 115
Registered: January 2012
Location: Hyderabad

Senior Member

two data blocks are there.like master and detail.In both the block i need to update columns.
thanks.

Report message to a moderator

Re: calling form error [message #565500 is a reply to message #565440]

Tue, 04 September 2012 15:17

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

As far as I can tell, no record should be INSERTED here ... try to run a form in debug mode and see what's going on.

Report message to a moderator

Previous Topic:	Direct Printing - Having error in java console relating to PDFBox-app-1.7.1.jar
Next Topic:	Forms 6i Key-help not fired under application

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 21 03:43:52 CDT 2026