Re: Multiple value passing between forms

In article <16292_at_dciem.dciem.dnd.ca> selina_at_dciem.dnd.ca (Selina Glynn) writes:
>One of my user wanted to select multiple values from a lookup table, and
>have the select values brought back to the calling field. I
>have asked oracle tech support, the person didn't know how to do it.
>There is no mention about multiple values passing in the manuals. I am
>new to oracle forms application development. Any suggestions or ideas
>are welcome. My idea is to add a checking column for the user to
>pick the values that he wants, but I have no clue as to how to pass the
>values back to the calling form/field.
>
>Thanks in advance for your help.
>
>Selina
>--
> Selina Wong-Glynn, DCIEM, Canadian Forces Base Toronto
>UUCP: {decvax|ihnp4|watmath}!utzoo!dciem!dretor!selina
> or uunet!mnetor!dciem!dretor!selina or nrcaer!dciem!dretor!selina
>Internet: selina_at_dretor.dciem.dnd.ca

Selina,

If I undertood you well you want to return multiple "rows" of data and not multiple column within a row. Then this is one way to do it:

1. create a specialized pick-list screen. Standard LOV in V3 will not work.
2. Add a display-only non-database field as "Selection Indicator" (i.e. "*" means selected, " " means not selected)
3. Create a list of Global variables as a stack. (i.e. GLOBAL.VAR1 to VAR10)
4. Allow the user to have a function key (say F1) to 'Select/Deselect' rows. As the key is presses, put a "*" in indicator and push the value in the appropriate GLOBAL.VARn using a counter and a FIFO stack method. If the field is already selected, then pop it out of the stack by clearing the indicator and the appropriate GLOBAL value.
5. when you return to the original calling form, create a looping logic to pop values from your stack and process your other logics approriately
6. Once the work is done, erase all GLOBAL vars to save some memory.

I have a template that does all of this. Creating it the first time around is a nightmare but then you can reuse the code afterwords.

Regards,
S. Tedjarati (stedjara_at_unisys.hk.net) Unisys China and Hong Kong Limited Received on Thu Dec 09 1993 - 09:19:26 CET