Re: Forms 4.5 PopLists Question

nickjost_at_mammoth.valleynet.com writes:

>This deals with Forms 4.5 Designer/2000 release. I have the following
>pre-form trigger:
 

>DECLARE
> Purch_Type_Code_List RecordGroup;
> Sale_Type_Code_List RecordGroup;
> List_ID1 Item := Find_Item('PURCH_TYPE_FK');
> List_ID2 Item := Find_Item('SALE_TYPE_FK');
> Status1 Number;
> Status2 Number;
>BEGIN
> Purch_Type_Code_List := Create_Group_From_Query('Purch_Type_IDs',
> 'SELECT to_char(purch_type.purch_type_pk),
> to_char(purch_type.purch_type_pk)
> FROM purch_type
> ORDER BY purch_type.purch_type_pk');
> Status1 := Populate_Group(Purch_Type_Code_List);
> Populate_List(List_ID1, Purch_Type_Code_List);
> Add_List_Element(List_ID1, 2, 'List2', '1');
> Delete_List_Element(List_ID1, 2);
>END;
 
>Now the frustrating part is that add_list and delete_list *work* but the
>populate_list gives the error:
> FRM-41337: Cannot populate the list from record group
 

>Suggestions more than welcome....

>Nick Jost
>Systems Analyst
>Standard-Rent-A-Car

Try defining a dummy list element in the properties sheet for the poplist. There seems to be a bug in populating an empty list. Oracle sent me a fax on the problem, I can look up the number later if you need it.

Bill Messick Received on Tue Apr 09 1996 - 00:00:00 CEST