Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: HELP : Dynamic List Items in Forms 4.5
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
![]() |
![]() |