(unknown charset) Re: Forms 6i / Pop Lists/ Record Groups
Date: Mon, 17 Mar 2003 18:06:11 +0000
Message-ID: <3E760E93.29FB2AE7_at_spammotel.com>
[Quoted] [Quoted] why are you modifying the ON-POPULATE-DETAILS
trigger?
This trigger is created in a default master-detail relationship.
leave any of these MD objects/triggers alone.
use CLEAR_LIST to flush the list before refreshing.
and try using a more suitable trigger for populating/refreshing your list.
Jeremy Ovenden wrote:
> In article <b54pto$43g$1_at_mailgate.ikea.com>, hgsh_at_memo.ikea.com says...
> > Populate_Group(Record Group);
> > Populate_List(Item,Reocrd Group);
>
> Hi! Thanks, this is the way and I found some other references. Only
> problem is that if I try to refresh the list, I get FRM-41337 Cannot
> populate list from record group.
>
> I created a trigger like this:
>
> DECLARE
> vs_group_id RecordGroup;
> vs_list_id Item := Find_Item('wd_fab_entity_entries.vs_id');
> status NUMBER;
> BEGIN
> vs_group_id := Create_Group_From_Query('vs',
> 'SELECT name,to_char(vs_id)
> from wd_vs
> where web_site_id = :control.web_site_id
> order by upper(name)');
> status := Populate_Group('vs');
>
> Populate_List(vs_list_id,vs_group_id);
> delete_group('vs');
> end;
>
> This works fine first time through (I call it in a ON-POPULATE-DETAILS
> trigger for the 'control' block).
>
> If a record is added to the table on which the record group is based, I
> need to refresh the list but this then yilds the FRM-41337.
>
> Can anyone suggest how/when a list should be repopulated in order to
> avoid the error?
>
> cheers!
>
> --
>
> jeremy
-- [Quoted] Suzuki SV650S - plop. Gone. Kwak ZX-6R J2 - hear the roarReceived on Mon Mar 17 2003 - 19:06:11 CET