Re: Forms 6i question

Luciano wrote:

> Hi,
>
> I have a table and I want to display it in a bidimensional way.
>
> Like:
>
> Table A with the fields:
>
> Factory varchar2(02)
> key varchar2(10)
> date date
> week number(02)
> year number(04)
> qty number(12,2)
>
> My screen :
>
> WEEK/YEAR WEEK/YEAR WEEK/YEAR WEEK/YEAR .....
> 02/2003 03/2003 04/2003 05/2003 ....
>
> key date week QTY QTY .....
>
> 010203 21/12/2002 52 200 300 .....
> 040506 02/01/2003 01 5 25 .....
> . . . . .
> . . . .
> . . . .
> . . . .
>
> Can someone give me a light ???
>
> Thank you.
>
> Luciano.

Build a view using DECODE to pivot the information. Build the form based on the view. But don't expect to have insert, update, and delete abilities unless you write an INSTEAD OF trigger.

Daniel Morgan Received on Sun Feb 23 2003 - 19:00:57 CET