Re: populate_list ???

A record group which is used to populate a list must have 2 columns. One is the displayed value and the other is the returned value. So your select statement should be something like:

              'SELECT DISTINCT to_char(clear_date,''MM/DD/RR''), to_char(clear_date,''MM/DD/RR'') '||

              'FROM ctrl_disp ');

In other words I have added clear_date as the returned value.

HTH
Geoff

Ken Halsted wrote:

> I just noticed I'm getting a FRM-41334 error (Invalid Record Group for List
> population)??!!
>
> What's going on!
>
> Ken.
>
> Ken Halsted <kenman_at_mail.snider.net> wrote in message
> news:s23qubf524240_at_corp.supernews.com...
> <snip>

> >
> <snip>

> > IF ID_NULL(rg_id) THEN
> > rg_id := CREATE_GROUP_FROM_QUERY( rg_name,
> > 'SELECT DISTINCT to_char(clear_date,''MM/DD/RR'') '||
> > 'FROM ctrl_disp ');
> > END IF;
> > /* Populate the record group */
> > errcode := POPULATE_GROUP(rg_id);
> > POPULATE_LIST('CTRL_DISP.LST_DATE',rg_id);
> > END;
> >
> > --
> <snip>

> >
Received on Fri Nov 05 1999 - 02:40:15 CET