Re: Combo box filling in

Try this stored proc with the following call:

PROCEDURE LoadList(item_name VARCHAR2, record_group_name VARCHAR2) IS

   lvItem_Id Item;
BEGIN
   lvItem_Id := Find_Item(item_name);

   if (populate_group(record_group_name) = 0) then

      populate_list(lvItem_Id,record_group_name);    end if;
END; LOADLIST('BLK_POWER_CIRCUITS.SC_SUBSTATION_CODE__ID','GRP_SUBSTATION_CODES') ;

• Note that GRP_SUBSTATION_CODES is a record group where the Query looks like select substation_code__desc, to_char(substation_code__id) from substation_codes order by substation_code__desc

(The first two fields must be varchar2)
(Also the combobox item must have type consistent with the first field.)

Hope that helps.

Graziano wrote in message <36BF2E01.752E7B0F_at_hotmail.com>...
>How can I fill in a combo box with values taken from a table column?
>
>Thanx in advance
>
Received on Tue Feb 09 1999 - 16:29:11 CET