Cross Table (Pivot Table) with Oracle Spread Table Control (MMTX32.OCX)

I'm looking for a nice and easy way to get a cross table result of Oracle. One way is to

    SELECT

        SUM(DECODE(col_key=key1, value, NULL)),
        SUM(DECODE(col_key=key2, value, NULL)),
        ...
    FROM
         mytable
    GROUP BY
        row_key;

but this is neither nice nor easy, so I found the MMTX.TableType-property. This can be set to MMTX_PIVOT, but how can it be used in VC++ and VB?

Thanks

AndyR Received on Tue Jun 06 2000 - 00:00:00 CEST