Re: How to populate a combo list programmatically???

From: Bob Sauer <rsauer_at_census.gov>
Date: Mon, 16 Nov 1998 09:13:37 -0500
Message-ID: <36503311.27EBD86D_at_census.gov>

Richard,

Try this.

PROCEDURE POPULATE_LIST_WITH_QUERY
   (p_list_item in VARCHAR2,
    p_query in VARCHAR2)
IS

   cat_rg_name constant VARCHAR2(30) :=

      GET_ITEM_PROPERTY(p_list_item, item_name);    v_rg_id RECORDGROUP;
BEGIN
   v_rg_id := FIND_GROUP(cat_rg_name);

   IF ID_NULL(v_rg_id) THEN

      v_rg_id := CREATE_GROUP_FROM_QUERY(cat_rg_name, p_query);    END IF;    IF POPULATE_GROUP(v_rg_id) = 0 THEN

      POPULATE_LIST(p_list_item, v_rg_id);

      COPY(GET_LIST_ELEMENT_VALUE(p_list_item, 1), p_list_item);    END IF; Usage is

      POPULATE_LIST_WITH_QUERY('control_block.valid_branches',
         'SELECT branch_name, branch_code from valid_branches where

div_code = :
control_block.valid_divisions order by branch_code');

Bob

Richard Hollingsworth wrote:

> Thanx for reading this.
>
> All my books tell me how to populate combo lists by using the property
> pallete, but this is hard coding the data. I need to know how to
> populate lists using pl/sql.
>
> How do you denote the list box?...and it's contents?? in pl/sql?
>
> Thanx for any advise.
>
> Richard H.
Received on Mon Nov 16 1998 - 15:13:37 CET