Home » Developer & Programmer » Forms » How to refresh calling form (Parent form) when called form is closed. (Oracle forms, 10G, Windows 7)
How to refresh calling form (Parent form) when called form is closed. [message #611697] Mon, 07 April 2014 07:33 Go to next message
pramod.sramesh
Messages: 23
Registered: November 2011
Location: Bangalore
Junior Member
Hi Experts,


I am working on Oracle forms 10g (OS: Windows7) from last 2 years. I have two forms form A (master form) and form B (Query only form). I am calling form A from form B to modify cost in master form. I used CALL_FORM and everything is working fine. Now i want to refresh the form B as soon as the cost is modified in master form and closed. I searched forum for the same, tried some suggestions using WHEN-WINDOW-ACTIVATED but this trigger is not firing when we close the master form and the focus comes back to calling form. Please share your useful comments.

Thanks,
Pramod S R
Re: How to refresh calling form (Parent form) when called form is closed. [message #611701 is a reply to message #611697] Mon, 07 April 2014 07:46 Go to previous messageGo to next message
cookiemonster
Messages: 13915
Registered: September 2008
Location: Rainy Manchester
Senior Member
How exactly are you calling form A? What code and what trigger is it in?
Re: How to refresh calling form (Parent form) when called form is closed. [message #611789 is a reply to message #611701] Wed, 09 April 2014 00:35 Go to previous messageGo to next message
pramod.sramesh
Messages: 23
Registered: November 2011
Location: Bangalore
Junior Member
Hi cookiemonster,

Thanks for your valuable time. I am using CALL_FORM option to call form A.

call_Form('FORMA',no_hide,no_replace,no_query_only,l_paramlist);

Please note that i am trying this in my local machine, forms are not compiled in application server yet.

Thanks,
Pramod

[Updated on: Wed, 09 April 2014 00:50]

Report message to a moderator

Re: How to refresh calling form (Parent form) when called form is closed. [message #611810 is a reply to message #611789] Wed, 09 April 2014 03:04 Go to previous messageGo to next message
cookiemonster
Messages: 13915
Registered: September 2008
Location: Rainy Manchester
Senior Member
So put an exeute_query command in form B immediately after the call_form command.
Re: How to refresh calling form (Parent form) when called form is closed. [message #611819 is a reply to message #611810] Wed, 09 April 2014 04:13 Go to previous message
pramod.sramesh
Messages: 23
Registered: November 2011
Location: Bangalore
Junior Member
Thanks cookiemonster. Your code is working for me.
https://community.oracle.com/message/12368181#12368181
Previous Topic: how can I find out only changed records
Next Topic: need to repeat process until the all data fetched
Goto Forum:
  


Current Time: Tue Mar 19 05:27:20 CDT 2024