Re: Forms 4.5 Populate_List Question

From: Sean McMurray <smcmurr_at_admin.dce.utah.edu>
Date: Tue, 18 May 1999 11:35:46 -0700
Message-ID: <3741B302.23DA1D7B_at_admin.dce.utah.edu>



>nickjost_at_mammoth.valleynet.com wrote-écrivait:
>
>>This deals with Forms 4.5 Designer/2000 release. I have the following

>>pre-form trigger:

<clipped>

>> 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....

<clipped>

>First, I suggest that you use a record group instead of creating the
group at runtime, that will eliminate
>the risk of sql error (syntax)

<clipped>

>Third, I ran into the error you have because I had already items into
my list. Populate_list should clear
>the list before populate (litterature) it but it seems it does not do
it. So before doing a populate list,
>I always do a CLEAR_LIST(list_id)
>
>Michel Lapierre
>Oracle specialist

I'm populating a group that was defined in the designer. POPULATE_GROUP returns 0, but POPULATE_LIST gives the FRM-41337 error. Calling CLEAR_LIST before POPULATE_LIST gives a "FRM-41331: Could not delete element from [list]." error. Received on Tue May 18 1999 - 20:35:46 CEST

Original text of this message