(unknown charset) Re: Forms 6i / Pop Lists/ Record Groups

From: (unknown charset) URNinja-ed <LCIYQBBEQVFA_at_spammotel.com>
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 roar
 
Received on Mon Mar 17 2003 - 19:06:11 CET

Original text of this message