HELP : Dynamic List Items in Forms 4.5

From: Joao Ricardo B Oliveira <jricardo_at_ipb.pt>
Date: Tue, 13 Jul 1999 17:58:09 +0100
Message-ID: <7mfqhl$vsp$1_at_pan.ipb.pt>

[Quoted] Hi there:

    Anyone here know the easy way to make a LIST_ITEM (Poplist or Combobox) getting values from a TABLE ?

    I've got a record group (named r_city with this SQL statement:     I've two columns in the record_group by a query...

    select to_char(code), city
    from table_a;

---

    code is number
    description is char;

I've this code by GREGG JACKSON in a Oracle Corporation Whitepaper...

---

 PROCEDURE build_lista IS

     tipo groupcolumn:=find_column('city');
     group_id recordgroup:=find_group('r_city');
     last_row number:=0;
     list_id  Item:=find_item('code');

    code groupcolumn:=find_column('code');

BEGIN

     if populate_group(group_id) <> 0 then
          message('Cannot create GROUP...');
          raise form_trigger_failure;
     end if;
     add_group_row(group_id, 1);
     set_group_char_cell(city,1,'');
     set_group_char_cell(code,1,'0');
     add_group_row(group_id, END_OF_GROUP);
     last_row:=get_group_row_count(group_id);
     clear_list(list_id);
     populate_list(list_id,group_id);

END; I execute this procedure in the WHEN-NEW-FORM-INSTANCE trigger...

Even i couldnt make i work...

WHAT CAN i DO to MAKE it WORK ???

Ricardo

mail me : jricardo_at_ipb.pt

ricardo
thankx !!!!! Received on Tue Jul 13 1999 - 18:58:09 CEST