Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to Automate the Query Search Upon Return to the Calling Form?

jtomasicDec 28 2009 — edited Dec 29 2009
Greetings Ya’ll Gurus,

Could you please share with me how to make the Query Search executed automatically each time, when database table is updated, upon return to the “Calling Form” (i.e. FormA in this posting) from the “Called Form” (i.e. FormB from here on)?

I have FormA call_form to FormB. FormB may return to FormA. FormA allows users to enter the Query parameters and perform query Search to the database table with a list of search results afterward; whereas FormB allows users to add or delete the same database table records. Both form images are as follows:

FormA:
!http://dot.state.ak.us/nreg/jtomasic/FormA_DWR_SEL.GIF!

FormA call_form to FormB by clicking PB “Daily Work Report” (see circled PB "Daily Work Report" in the above image.)

FormB Image (FormB allows users to add and delete database records):
!http://dot.state.ak.us/nreg/jtomasic/FormB_DWR.GIF!

FormB EXIT_FORM and returns to FormA (see circled PB "DWR Selection" in above image).

Currently, our users must press the PB “Search” on FormA each time to refresh the Query “Search” results after returning to FormA, and they request to have the "Search" done automatically/programmatically upon return to FormA each time when the database table is updated.

If you have programming code on this and are willing to share or if you have any suggestion or thoughts on this, it would be most greatly appreciated.

Thanks a lot & Happy Holidays!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 26 2010
Added on Dec 28 2009
13 comments
1,408 views