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

From: Andreas Rothenwaender <Andreas.Rothenwaender_at_safe.at>
Date: 2000/06/06
Message-ID: <960291596.585719_at_peppi>#1/1


[Quoted] 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

Original text of this message