Get paid to test things

Oracle Form 6i: How to put database data into List Item(Combo Box)?

Last days around, i just tried to make some List Item(ComboBox) that filed from database selected. . .
Its pretty good and easy enough.

1.

Create Program Unit :


PROCEDURE CREATE_Filenames_RG  IS
-- Andrew Fraser v2.2 27th May 2010
-- Populate dynamic lookup

    it_id1   Item := Find_Item(block.my_list_item);

    group1_id    RecordGroup;

    GRP_status       NUMBER;

    V_Space varchar2(10) := ||0||;

BEGIN

  group1_id := Find_Group(FILENAMES_RG);

  IF NOT Id_Null(group1_id) THEN
   delete_group(group1_id);
  END IF;
  group1_id := Create_Group_From_Query(FILENAMES_RG,
        SELECT field FROM table ORDER BY field) ;

    Grp_status := Populate_Group(FILENAMES_RG);
   IF Grp_status = 0 THEN
If Not Id_Null(it_id1) THEN
  If Get_Item_Property(it_id1,Item_Type) = LIST Then
   Clear_List(it_id1);
   Populate_List(it_id1,FILENAMES_RG);
    END IF;
END IF;
END IF;

End;

2.

Create/edit triggers to call this:

When-New-Form-Instance on the form as a whole:

CREATE_Filenames_RG;

3.

And/or on mouse click if you want the database table requeried every single time the user clicks on the dropdown:

When-Mouse-Click on the new item itself:

Clear_List(CAS_UPLOAD);
Clear_Item;
CREATE_Filenames_RG;
easy right??