Re: Implementing selectable LOV, how to...

From: <kmallory_at_us.oracle.com>
Date: Thu, 6 Aug 1992 05:36:47 GMT
Message-ID: <1992Aug5.213647.1_at_us.oracle.com>

In article <1992Aug4.164432.12930_at_unixg.ubc.ca>, george_at_unixg.ubc.ca (George chow) writes:
> Hello,
> I'm trying to implement a LOV from which a user is allowed to pick multiple
> values. I'm thinking of something similar to the <Select Columns> in
> SQL*Forms's Default Block form. Other than that is is a pop-up page, I have no
> real idea of how to approach this. So has anyone here tried to do anything
> similar to this?
>
> George
>
>

You have already discovered most of the solution to your problem. SQL*Forms 3.0 does not support selecting multiple rows from an LOV. To do this yourself create a pop-up page, and then assign the user a key which is a 'select-record' key, in the trigger for that record, change the visual attributes of the record, and when the user dismisses the pop-up page, loop thru the records in the block to see which ones have the new visual attribute.

Note: this can be quite time consuming depending on the number of records you retrieve into the pop-up page block. You might consider other methods of returning the selected records to the block you want to populate. For example, to let the user know that they've selected the record, change the visual attributes of is in the appropriate trigger, then stash the rowid of the row(s) they selected into a global variable, then when they dismiss the multi-select pop-up page query the records by rowid. Note this will require you to select the rowid's of the rows into a field, and correctly formulated the LOV can hide the rowid. (excercise left to the reader (grin)).

Kevin

---

"QUALITY is never an accident; it is always the result of high intention,  sincere effort, intelligent direction and skillful execution; it represents  the wise choice of many alternatives."

Kevin Mallory                                           SQL*Forms Development
                                                        Oracle Corporation
-------------------------------------------------------------------------------

Received on Thu Aug 06 1992 - 07:36:47 CEST