Re: Dynamic LOV Problem
Date: Sat, 10 Feb 2001 18:56:22 +0300
Message-ID: <963ocl$lfo$1_at_news.wplus.spb.ru>
"Lesley Boughner" <lesley_at_vimich.com> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
news:9612f70pf1_at_enews2.newsguy.com...
> Hello everyone.
>
> I'm having a problem populating a list of values dynamically.
> I'm not getting an error, but my lov will not display. It will display
with
> the old query if I remove the line:
>
> Set_LOV_Property(lov_id, Group_Name, Qry_Name)
>
> But once I add it it will not display. In the status bar it specifies
there
> is a LOV associated with the item I have it tied to. But even if I hit F9
> it won't display.
>
> On the item I have the LOV name set and validate from List = Yes.
> I also have two columns mapped in the LOV itself.
>
> The entire trigger is below.
> If you need any more info let me know.
> Thanks for your help.
> Lesley Boughner
>
>
> Declare
> lov_id LOV;
> v_BTCoid number;
> group_id recordgroup;
> Qry_name varchar2(40) := 'Qry_Test';
> dummy boolean;
> errcode number;
>
> Begin
>
> if :Dispatch.Disp_BillTo is null then
> :Dispatch.BilltoCoid := null;
> End if;
>
> If :Dispatch.Billtocoid is null then
> Message ('You must fill in a Bill To Company Name, or leave the
default');
> RAISE Form_Trigger_Failure;
> else
> v_BTCoid := :Dispatch.BilltoCoid;
>
> Group_ID := Find_Group(Qry_Name);
>
> If not Id_Null(Group_ID) then
> delete_group(Group_ID);
> end if;
> If ID_NULL(Group_ID) then
> Group_ID := Create_Group_From_Query(Qry_Name,
> 'Select ContactID, Firstname from Cocontacts
ContactID must be a string so you must convert it with to_char if it is a number. This feature is
described in Forms help.
> where Coid = ' || v_BTCoid);
> errcode := populate_Group(group_id);
> lov_id := Find_Lov('LOV_Contacts');
> Set_LOV_Property(lov_id, Group_Name, Qry_Name);
> dummy := show_lov('LOV_Contacts', 204,75);
> End if;
>
> End if;
> End;
>
Received on Sat Feb 10 2001 - 16:56:22 CET