Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Help Requested: Dynamically Filing List Field

Help Requested: Dynamically Filing List Field

From: Daniel A. Morgan <dan.morgan_at_pss.boeing.com>
Date: 1997/03/16
Message-ID: <332C6149.4F98@pss.boeing.com>#1/1

I am trying to dynamically build a list on a form. I want the list to automatically update itself based on a SELECT each time the form is opened.

The object is: 'Item Type = LIST'

I have tried a number of different triggers for the following code including 'WHEN-NEW-FORM-INSTANCE' without success.

DECLARE

   group_id	RecordGroup;
   list_id	Item := Find_Item('LS_SKILL_TYPE');
   status	number;

BEGIN
   group_id := Create_Group_From_Query('gr_skill_type',

      'SELECT distinct(skill_type_text),skill_type_text FROM SKILL');    status := Populate_Group('gr_skill_type');    Populate_List(list_id,group_id);
END; Can anyone help me with what to do. Please respond to dan.morgan_at_pss.boeing.com.

Thanks.

Daniel A. Morgan Received on Sun Mar 16 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US