Home » Developer & Programmer » Forms » frm 40403 - calling form has not implemented changes (FORM 4.5)
frm 40403 - calling form has not implemented changes [message #517901] Fri, 29 July 2011 05:40 Go to next message
umesh337
Messages: 26
Registered: July 2011
Location: pune
Junior Member
I have two forms, A and B and form A is calling form B. And when I am committing form B I am getting this error message. I don't want to commit form A before committing form B. Is their any solution to commit both forms in different session.


Regards,
Umesh

Report message to a moderator

Re: frm 40403 - calling form has not implemented changes [message #517903 is a reply to message #517901] Fri, 29 July 2011 06:23 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
How do you call form B?

[Updated on: Fri, 29 July 2011 06:24]

Report message to a moderator

Re: frm 40403 - calling form has not implemented changes [message #518014 is a reply to message #517903] Sun, 31 July 2011 08:40 Go to previous messageGo to next message
umesh337
Messages: 26
Registered: July 2011
Location: pune
Junior Member
I have took the "where clause" from FORM A i have to put in B form as default in a global variable and called the form B through the trigger WHEN-NEW-INSTANCE-FORM where previous form was A and next form is B and put that default "where_clause" at the first block of form B.
I also put the command POST; at the trigger of button which calling form B.

Report message to a moderator

Re: frm 40403 - calling form has not implemented changes [message #518028 is a reply to message #518014] Sun, 31 July 2011 17:56 Go to previous messageGo to next message
cookiemonster
Messages: 13937
Registered: September 2008
Location: Rainy Manchester
Senior Member
Littlefoot is asking what exact command you use in form A to call form B.

Report message to a moderator

Re: frm 40403 - calling form has not implemented changes [message #518121 is a reply to message #518028] Mon, 01 August 2011 07:03 Go to previous messageGo to next message
umesh337
Messages: 26
Registered: July 2011
Location: pune
Junior Member
call_form('Form_B',NO_HIDE,NO_REPLACE);

Report message to a moderator

Re: frm 40403 - calling form has not implemented changes [message #518124 is a reply to message #518121] Mon, 01 August 2011 07:12 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You said you used POST; where? Before or after CALL_FORM? (should be before)

Report message to a moderator

Re: frm 40403 - calling form has not implemented changes [message #518347 is a reply to message #518124] Wed, 03 August 2011 05:26 Go to previous messageGo to next message
umesh337
Messages: 26
Registered: July 2011
Location: pune
Junior Member
I put the post; just previous to the call_form.
But it's not working and showing same error. Sad

Report message to a moderator

Re: frm 40403 - calling form has not implemented changes [message #518349 is a reply to message #518347] Wed, 03 August 2011 05:43 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
No idea. I created two forms, entered values into the first one, called another (WHEN-BUTTON-PRESSED), entered values into the second one, commited - no problem.

You said that you called the second from in WHEN-NEW-FORM-INSTANCE trigger. Is that still true? What is then the first form used for? You don't even see it, do you? If possible, post the whole trigger (that calls the form) (also, use [code] tags to preserve formatting). Also, check what happens if you call the second form from a button.

Report message to a moderator

Re: frm 40403 - calling form has not implemented changes [message #518360 is a reply to message #518349] Wed, 03 August 2011 07:09 Go to previous messageGo to next message
umesh337
Messages: 26
Registered: July 2011
Location: pune
Junior Member
Hi Littlefoot,

Just ignore about when-new-form-instance trigger.
on first form A there is a button.
On pressing that button the below given functionality call:

if upper(name_in('global.present_form')) = 'form_A'
and upper(p_next_form) = 'form_B'
then
statements;
end if;

--Now we used both the trick for post given as below:

1> post;
call_form(p_next_form,NO_HIDE,NO_REPLACE);

2> IF name_in('system.Form_Status') = 'CHANGED'
THEN
message('In POST block');
message(' ');
POST;
END IF;
call_form(p_next_form,NO_HIDE,NO_REPLACE);

In second case, It's displaying the message but on the time of saving the form B it's throwing the same error.

Please let me know if any further details you need.

Report message to a moderator

Re: frm 40403 - calling form has not implemented changes [message #518362 is a reply to message #518360] Wed, 03 August 2011 07:16 Go to previous messageGo to next message
cookiemonster
Messages: 13937
Registered: September 2008
Location: Rainy Manchester
Senior Member
Use message to display form_status and all relevant block_status before and after the post command in form A.

Report message to a moderator

Re: frm 40403 - calling form has not implemented changes [message #518463 is a reply to message #518362] Thu, 04 August 2011 00:49 Go to previous messageGo to next message
umesh337
Messages: 26
Registered: July 2011
Location: pune
Junior Member
Hi,

Please confirm me one thing.
Whenever we are putting POST; command, then what procedure it is following to save the changes temporarily.
I might get the answer from this i think.

Thanks.

Report message to a moderator

Re: frm 40403 - calling form has not implemented changes [message #518470 is a reply to message #518463] Thu, 04 August 2011 01:20 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
From the documentation:Oracle

POST writes data in the form to the database, but does not perform a database commit. Forms Developer first validates the form. If there are changes to post to the database, for each block in the form Forms Developer writes deletes, inserts, and updates to the database.

Any data that you post to the database is committed to the database by the next COMMIT_FORM that executes during the current Runform session. Alternatively, this data can be rolled back by the next CLEAR_FORM.

Report message to a moderator

Re: frm 40403 - calling form has not implemented changes [message #518834 is a reply to message #518470] Mon, 08 August 2011 00:43 Go to previous messageGo to next message
umesh337
Messages: 26
Registered: July 2011
Location: pune
Junior Member
Hi Littlefoot,

If the source and destination database table for the form is same and
There is only one column value changes in same table after saving the form.

then will it execute the POST; command as usual ?

Report message to a moderator

Re: frm 40403 - calling form has not implemented changes [message #518838 is a reply to message #518834] Mon, 08 August 2011 01:25 Go to previous message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
POST works always, and it doesn't care whether there are any changes in a form or not. If YES, it will post those changes. If NO, it won't post anything (but it won't fail either, if that's what you ask).

Report message to a moderator

Previous Topic: trunc function
Next Topic: convert from 6i to 10g
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Sep 08 23:00:55 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.