Re: HELP : Dynamic List Items in Forms 4.5

From: Andy Hardy <aph_at_ahardy.demon.co.uk>
Date: Wed, 14 Jul 1999 00:49:36 +0100
Message-ID: <HsYTJJAQC9i3EwmF_at_ahardy.demon.co.uk>


In article <7mfqhl$vsp$1_at_pan.ipb.pt>, Joao Ricardo B Oliveira <jricardo_at_ipb.pt> writes
>Hi there:
>
> Anyone here know the easy way to make a LIST_ITEM (Poplist or Combobox)
>getting values from a TABLE ?
> I've got a record group (named r_city with this SQL statement:
> I've two columns in the record_group by a query...
>
> select to_char(code), city
> from table_a;
>--------------------------------------------------
> code is number
> description is char;
>
>I've this code by GREGG JACKSON in a Oracle Corporation Whitepaper...
>---------------------------------------------------
> PROCEDURE build_lista IS
> tipo groupcolumn:=find_column('city');

Find_column should include the group e.g. find_column('my_group.my_colum n');

Andy

-- 
Andy Hardy. PGP key available on request
===============================================================
Received on Wed Jul 14 1999 - 01:49:36 CEST

Original text of this message