Re: Can I populate a list with data from the database?
From: Daniel Lisiecki <lisu_at_venus.wmid.amu.edu.pl>
Date: Fri, 06 Aug 1999 10:01:52 GMT
Message-ID: <koyq3.505$X3.5755_at_news.tpnet.pl>
Date: Fri, 06 Aug 1999 10:01:52 GMT
Message-ID: <koyq3.505$X3.5755_at_news.tpnet.pl>
Hi
List item is combo type in this case
When-New-Form-Instance trigger body:
DECLARE
rg_name varchar2(20):='kto_rg'; --record group name
rg_id RecordGroup; --record group declaration
item_id Item := Find_Item('BLOCK.ITEM'); --id of list to populate
error Number; --error code
BEGIN
rg_id:=Find_Group(rg_name); --does such group exist?
if Id_Null(rg_id) then --if not then create it from query
rg_id:=Create_Group_From_Query (rg_name,
'select u.opis,opis from uzytkownik u order by u.opis',
FORM_SCOPE,
20);
end if;
error:=Populate_Group(rg_id); --fill record group
Populate_List(item_id,rg_id); --fill list with recordgroup
END;
rg_name varchar2(20):='kto_rg'; --record group name
rg_id RecordGroup; --record group declaration
item_id Item := Find_Item('BLOCK.ITEM'); --id of list to populate
error Number; --error code
BEGIN
rg_id:=Find_Group(rg_name); --does such group exist?
if Id_Null(rg_id) then --if not then create it from query
rg_id:=Create_Group_From_Query (rg_name,
'select u.opis,opis from uzytkownik u order by u.opis',
FORM_SCOPE,
20);
end if;
error:=Populate_Group(rg_id); --fill record group
Populate_List(item_id,rg_id); --fill list with recordgroup
END;
But please read older question on news first. I
have answered on this question 02.Aug.99 (?).
Daniel Lisiecki
Received on Fri Aug 06 1999 - 12:01:52 CESTFiona Ruddy <fiona.ruddy_at_mallon.demon.co.uk> wrote in message news:933931888.13639.0.nnrp-02.9e98496d_at_news.demon.co.uk...I am trying to populate a list from data in the database but don't know how. I could enter the data directly using the properties but this is very inefficient.Any suggestions?