Re: LOVs & DROP DOWN Lists inf FORMS 4.5

From: Peter de Goederen <goederen_at_worldonline.nl>
Date: 1998/02/16
Message-ID: <01bd3a95$0f303e80$6983f1c3_at_goederen>#1/1

Pop-lists can be populate in the like this:

PROCEDURE CGDV$POPULATE_DYNAMIC_LISTS IS /* Read each lists values from its record group and populate the list */   temp NUMBER; /* Return value of populate_group call */   rg_id RecordGroup; /* Return value of populate_group call */ BEGIN
  rg_id := create_group_from_query('CGDV$DLRG',

    'select RV_LOW_VALUE, RV_LOW_VALUE '||
    'from   PIT_REF_CODES '||
    'where  RV_DOMAIN = ''LETTERTYPE'' '||
    'order by  2');

  temp := populate_group(rg_id);
  populate_list('TKS.LETTERTYPE', rg_id);   delete_group(rg_id);
end;

where tks.lettertype is the poplist in the form. Good-luck

Ed Jennings <jenningse_at_mindspring.com> schreef in artikel <34E3A158.A4F_at_mindspring.com>...
> I have an item on a canvas that I want to use as a drop-down list.
> But I don't want the values hard coded in the form. I want an LOV
> that queries a table at run-time to populate the list. The problem is
> that I can only get a true drop-down list if I hard-code the values.
> If I try to use an LOV, I have to then put a button next to the item
> with a WJEN-BUTTON-PRESSED trigger. But this brings up a whole new
> window to display the list. I don't want that. I just want the
> vanilla pull-down list, dynamically built. Can this be done? Or
> am I asking too much of FORMS?
>
> TIA
> Ed Jennings
>
> --
> ~~~~~~~~~~~~~~~~~~~~~~~~~
> jenningse_at_mindspring.com
>
> "The opinions expressed here are my own, not those of DOMAIN
> technologies"
>
Received on Mon Feb 16 1998 - 00:00:00 CET