how to use a list box

[bookouri]

Ive been using list boxes in Oracle Developer 6i to populate fields. But these are all simple drop down lists where I put in the items manually when I build the form. How can I use a query to populate the drop down list. Ive looked through the form builder help files all morning and cant find any help on how to accomplish this.

any suggestions would be appreciated...

 

[Hehenka]

I think that you have to use POPULATE_LIST built-in. There is also a little example in the on-line help:

/*
** Built-in: POPULATE_LIST
** Example: Retrieves the values from the current list item
** into record group one, clears the list, and
** populates the list with values from record group
** two when a button is pressed.
** Trigger: When-Button-Pressed
*/
BEGIN
Retrieve_List(list_id, 'RECGRP_ONE');
Clear_List(list_id);
Populate_List(list_id, 'RECGRP_TWO');
END;

I hope this will be a little help for you.

Helena

 

[bookouri]

I found a similar snip of code somewhere, but none of the instructions tell actually where or how to use the code.