Re: populate_list ???

[Quoted] 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...
> I have this on a pre-block trigger in block 'CTRL_DISP'. Why doesn't my
> list get populated. CTRL_DISP.LST_DATE is defined as a char (10).
>
> What more do I need? I've been working on it for about an hour now.
>
> Please help!!!! :-)
>
> Thanks,
>
> Ken.
> ====================================
>
> DECLARE
> errcode NUMBER := 0;
> rg_id RecordGroup;
> rg_name VARCHAR2(40) := 'RG_DATES';
> BEGIN
> /* see if group exists */
> rg_id := FIND_GROUP( rg_name );
>
> /* If not exist, create */
> 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;
>
> --
> _________________
> Kenneth W. Halsted
> Mountaire Corporation
> ph: (501) 399-8812
> url: http://www.mountaire.com
> email: kenman_at_mail.snider.net
>
>
>
Received on Thu Nov 04 1999 - 23:41:25 CET