Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

POPULATING DATA INTO LISTBOX PROBLEM(forms 6.0)

532810Sep 11 2006 — edited Sep 11 2006
Hi all

I am using Forms 6.0

One problem is arissing when i am populating a listbox when filling in runtime

I had filled data's from a table by using create_group_from query like as below

DECLARE

Rg_id record group;

BEGIN

CLEAR_LIST('LIST_BOX');

Rg_id := Create_Group_From_Query('example',
'SELECT NAME,PLACE FROM SCMASTER);
ERRCODE := POPULATE_GROUP('LIST_BOX');
POPULATE_LIST('LIST_BOX','example');

END;

In the first case no problem occur (ie when I am written in when_new_from_instance)

But
I have to fill data accoding to a certain condition from user request , it make problem

ie if user enter Y in a text box

i have to fill data from one table

if the user enter N in a text box

i have to clear previous data from the list box and again trying to fill into the
list box

this makes error

thanks in advance
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 9 2006
Added on Sep 11 2006
1 comment
312 views