How to implement search capabilities in Oracle Forms 6

From: ORA-LEARNER <itsashok_at_gmail.com>
Date: 11 May 2005 11:04:18 -0700
Message-ID: <1115834658.468561.18050_at_g49g2000cwa.googlegroups.com>

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 ListBox2.

LOV is an immediate solution but it is limited by the fact that we ca select only one value at a time.

Any ideas?
TIA. Received on Wed May 11 2005 - 20:04:18 CEST