Re: Forms 6i / Pop Lists/ Record Groups

From: Jeremy Ovenden <newspostings_at_hazelweb.co.uk>
Date: Mon, 17 Mar 2003 17:22:08 -0000
Message-ID: <MPG.18e00465e26b2a059896d5_at_news.cis.dfn.de>

In article <b54pto$43g$1_at_mailgate.ikea.com>, hgsh_at_memo.ikea.com says...
> Populate_Group(Record Group);
> Populate_List(Item,Reocrd Group);

[Quoted] 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

Received on Mon Mar 17 2003 - 18:22:08 CET