PDA

View Full Version : Help on Multiselect LOVs in Oracle forms


OraRepDvlpr
05-12-2005, 01:13 PM
Can we alter the default selection in LOV (which is One value only)in
Oracle Forms 6i so that user can select more that one values at a time
and the selected values are stored/returned in a list box. Here is the
back ground to this.

I want to implement following search capabilities in Oracle Forms.
Here is the sequence of steps :
1) User inputs a search string in Text Item and hits
Enter/Return(same like Find % feature in Oracle LOV). The problem is we

can select only one value in LOV but in my case user needs to select
more than one values as explained in step 3 below.
2) System returns the matching values from table and displays them in

list box say ListBoxA.
3) User selects values (Mouse Double click , Ctrl, Shift )from
ListBoxA and these values are moved to ListBoxB.
4) The selected values are passed as parameters to the report and
results are generated for values in ListBoxB.


Any ideas?
TIA.

Daniel Morgan
05-12-2005, 03:03 PM
ORA-LEARNER wrote:
Can we alter the default selection in LOV (which is One value only)in Oracle Forms 6i so that user can select more that one values at a time and the selected values are stored/returned in a list box.

No. You will need to code your own dialog box.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)

Chris F
06-10-2005, 07:02 AM
ORA-LEARNER wrote: Can we alter the default selection in LOV (which is One value only)in Oracle Forms 6i so that user can select more that one values at a time and the selected values are stored/returned in a list box. Here is the back ground to this.

There used to be a neat sample shipped with the Oracle Forms toolkit for
a picklist widget. We've used it in our applications where we wanted a
multi-select behavior.

Also, (vague memories here) someone once did a paper at ODTUG on
creating your own multi-select widget and putting it into an OLB to
share amongst many forms. I haven't used this one though.


MyLounge.com Site Map
Forum: Cars, Cell Phone, Database, Games, Home Improvement, IT, Music, School, Sports, Web Design, Web Server, Weight Loss

The MyLounge.com forum is intended for informational use only and should not be relied upon and is not a substitute for any advice. The information contained on MyLounge.com are opinions and suggestions of members and is not a representation of the opinions of MyLounge.com. MyLounge.com does not warrant or vouch for the accuracy, completeness or usefulness of any postings or the qualifications of any person responding. Please consult a expert or seek the services of an attorney in your area for more accuracy on your specific situation. Please note that our forums also serve as mirrors to Usenet newsgroups. Many posts you see on our forums are made by newsgroup users who may not be members of MyLounge.com Term of Service