Q: FORM submit without resetting values
Date: 20 Nov 2003 15:53:37 -0800
Message-ID: <3fbd5401_at_news.victoria.tc.ca>
[Quoted] I have a form, made using Forms [32 Bit] Version 6.0.8.8.0 (Production)
On it I have a DATA block MENU containing several items, such as a checkbox called SUMMARY. These items do not tie into any database objects, they are just used to select the appropriate report file to use.
[Quoted] I wish these items to keep their values during the time the form is open, but the values are reset each time the user submits a report (as described below).
The DATA block MENU also contains a button called SUBMIT.
The SUBMIT button WHEN-BUTTON-PRESSED trigger simply calls a routine called SUBMIT_REPORT. That procedure selects a report file based on the values of the SUMMARY checkbox and similar items, and then calls COMMIT_FORM to force various other values in blocks that do tie into a table to be saved, and then calls Run_Product to launch oracle reports with the appropriate report file.
My issue is that the SUMMARY checkbox (and similar items in the MENU datablock) all get reset to their initial values when this happens, whereas I want them to simply keep what ever value the user has already set (not permanently, just during the current session).
Sounds very simple, but I don't see a way to automatically do this. I suspect I am simply looking in the wrong place, or searching the wrong keywords, or misunderstanding some terminology.
On obvious work around is to save the values in temporary variables at the start of the submit_report routine, and then use those values to reset the options back to whatever the user had chosen, and I am going to do this if necessary, but it's hard to believe there isn't simply an optional setting somewhere that tells the form to just keep these values.
feedback welcome. Received on Fri Nov 21 2003 - 00:53:37 CET