Re: Forms PopupList

Hmmmmm I think that u should give 2 items in your select to populate list, one to be shown on list and the second to be a value of first item. so, select should be like select s.sid, s.value from sid s Maciej Myrcha
"immo" <iwetzel_at_gmx.de> wrote in message news:86qbol$r2s$1_at_nnrp1.deja.com...
> 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;
> rg_id:=Find_Group('listgroup');
> IF not Id_Null(rg_id) Then
> message('record group exists',ACKNOWLEDGE );
> end if;
> errcode := Populate_Group(rg_id);
> Retrieve_list(list_id,rg_ido);
> clear_list(list_id);
> Populate_List(list_id,rg_id);
> end;
>
>
> but i get everytime the error 41334 Invalid record group.
>
> Whats happen ?
>
> Thanks for any suggestion
>
> Immo
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Jan 28 2000 - 09:20:11 CET