Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Help Requested: Dynamically Filing List Field
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
![]() |
![]() |