Re: List-items in Oracle Forms

Jack,

Here is the code that you need to put in your PRE-FORM trigger:

DECLARE
  rg_name VARCHAR2(40) := 'Dept_RG';
  rg_id RecordGroup;
  errcode NUMBER;
BEGIN
  rg_id := CREATE_GROUP_FROM_QUERY(rg_name,

             'SELECT dname, to_char(deptno) FROM dept');   errcode := POPULATE_GROUP(rg_id);
  POPULATE_LIST('EMP.DEPTNO', rg_id);
END; Hopefully you can figure out what everything is.

Matt.

Jack wrote:
>
> Hi
>
> Does anyone own a running example of an Oracle Forms module with
> list-items filled dynamically from a database table ? I say
> "list-item", like list of fonts in Word, not "L.O.V." ... I have
> created a record group with 2 columns, then created a
> WHEN-CREATE-RECORD block trigger with :
> clear_list('LIST1'); (name of the list item)
> populate_list('LIST1','GROUP1');
>
> It doesn't work, the list is always empty !
>
> Many thanks for help.
Received on Fri Dec 21 2001 - 17:10:25 CET