Home » Developer & Programmer » Forms » calling form error (oracle forms 10g)
calling form error [message #565380] Tue, 04 September 2012 03:22 Go to next message
furqan
Messages: 112
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.
Re: calling form error [message #565428 is a reply to message #565380] Tue, 04 September 2012 07:03 Go to previous messageGo to next message
Littlefoot
Messages: 19349
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)?
Re: calling form error [message #565429 is a reply to message #565428] Tue, 04 September 2012 07:13 Go to previous messageGo to next message
furqan
Messages: 112
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..
Re: calling form error [message #565431 is a reply to message #565429] Tue, 04 September 2012 07:18 Go to previous messageGo to next message
Littlefoot
Messages: 19349
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?
Re: calling form error [message #565440 is a reply to message #565431] Tue, 04 September 2012 07:58 Go to previous messageGo to next message
furqan
Messages: 112
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.
Re: calling form error [message #565500 is a reply to message #565440] Tue, 04 September 2012 15:17 Go to previous message
Littlefoot
Messages: 19349
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.
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:
  


Current Time: Fri Aug 01 11:28:39 CDT 2014

Total time taken to generate the page: 0.06110 seconds