Re: recordgroup in listitem

Paul:

I think there might be a problem with your query. After you populate the recordgroup, make sure that rows were returned. You can check this by looking up the return value of POPULATE_GROUP function. If this is 0 then the query worked, else the Oracle error number is returned.

Example:

       status := populate_group('test');
       if status != 0
       then
           messge('Error populating group TEST');
       else
           populate_list('list_ipnet','test');
       end if;

Hope this helps......
Vikram

On Thu, 2 Apr 1998, Paul Kreis wrote:

> hello,
>
> Oracle Forms 4.5, on Solaris 2.5.1
>
> what i do wrong. I want to display the contents of a recordgroup in a
> Listitem.
> I created the following trigger without compileerrors.
> But when I run the form the Listbox is empty.
>
> declare
> group_id recordgroup;
> status number;
>
> begin
>
> group_id := create_group_from_query('test', 'select
> ipnet_test.ipnet,ipnet_test.ipnet_id from ipnet_test');
>
> status := populate_group('test');
>
> populate_list('list_ipnet','test');
>
>
> end;
>
> Could anyone help me?
>
> regards
> paul
> --
> =================================================================
> Paul C. Kreis Informatiker Ascom
> Phone: ++41(0)31 999 6605
> paul.kreis_at_ascom.ch Natel: ++41(0)79 432 0514
>
>
Received on Thu Apr 02 1998 - 00:00:00 CEST