Re: Forms PopupList

A list always needs 2 columns: a description column and a value column. So your code should look something like:

        rg_id:=create_group_from_query('listgroup','select s.sid desc, s.sid val from sid s');

Note the column aliases are not mandatory - they just look nicer.

HTH Geoff

immo wrote:

> Hello
>
> I have try to make a popuplist with Oracle Forms 6 which should be
> filled out by clicking on abutton from the database.
>
> So i have created following trigger
>
> declare
> rg_id RECORDGROUP;
> rg_ido RECORDGROUP;
> errcode NUMBER;
> list_id ITEM:=find_item('SIDLIST');
> begin
> rg_id:=Find_Group('listgroup');
> IF Id_Null(rg_id) Then
> rg_id:=create_group_from_query('listgroup','select s.sid from
> sid s');
> end if;
> <snip>
Received on Fri Jan 28 2000 - 00:00:00 CET