Dynamic LOV Problem

From: Lesley Boughner <lesley_at_vimich.com>
Date: Fri, 9 Feb 2001 10:33:04 -0500
Message-ID: <9612f70pf1_at_enews2.newsguy.com>

[Quoted] 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 [Quoted] 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 [Quoted] 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
[Quoted]   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,

[Quoted]        'Select ContactID, Firstname from Cocontacts
       where Coid = ' || v_BTCoid);

[Quoted]     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 Fri Feb 09 2001 - 16:33:04 CET