Re: populate

I don't know exactly if something else is wrong, but in your select statement there should be blanks at the end or at the beginning  of each string(i.e. before the "select", the "from" and the "order by"):
 rg_id := create_group_from_query('CGDV$DLRG',

     ' select RV_MEANING,RV_LOW_VALUE'||
     ' from TRS_REF_CODES'||
     ' order by 2');

regards hans-dieter  

hasan schrieb:
>
> Could someone tell me what I'm doing wrong? I'm trying to populate a list
> item, but it didn't work. And I have tried several triggers.
> WHEN-LIST-CHANGED;
>
> declare
> temp NUMBER; /* return value of populate_group call */
> rg_id RecordGroup; /* return value of populate_group call */
> BEGIN
> rg_id := create_group_from_query('CGDV$DLRG',
> 'select RV_MEANING,RV_LOW_VALUE'||
> 'from TRS_REF_CODES'||
> 'order by 2');
> temp := populate_group(rg_id);
> populate_list('list_item',rg_id);
> delete_group(rg_id);
> END;
Received on Thu Apr 12 2001 - 00:07:41 CEST