--- In firebird-support@yahoogroups.com, "Fidel Viegas"
<fidel.viegas@...> wrote:

>
> On Fri, Apr 25, 2008 at 11:27 AM, Michael Vilhelmsen
> <Michael.Vilhelmsen@...> wrote:
>
> >
> > This works for the specific example.
> >
> > But I have simplified it a lot.
> > The X_Akse can have many values (more than just BLACK and WHITE).
> > In practice it contains some 10-20 diff. values.
> >
> > The same goes for the Y_Akse.
> > This can also contain more than 3 values.
> > In practice it contains some 60 - 200 values.
>
> What are the combinations allowed? Do you have a more complex example?
> It is hard to picture what you are trying to achieve with just this
> small sample.
>

Any combination is allowed.
There are only 3 fields in the table.
Its something that comes from a grid.

So it has an x columns and y rows with fieldvalue in them.

It can be something like this:

A B C D E F G...
AA 1 2 3 4 5 6 7...
BB 8 8 8 8 8 8 8...
CC 9 10 12 14 16 18 20...
DD 21 31 41 51 61 71 81...
....


It think its called "pivot" or something a like in access.

But Im not sure....

Point is - There can be many rows and many columns.

I would like to fetch all rows as shown above.
Only I dont know the exact amount of ros or columns.
At least 1 of each ....

Michael