ADE User Guide > ADE Server Class Reference > CATable
property int NumColumnIndexes
This property is used to access information about the table pivot that would be used by desktop Analytica (DTA) to view this table. Information about the pivot is stored in several attributes, such as ReformDef and ReformVal, but is computed based on this information and several additional heuristics that take several other factors into account, including the lengths of the indexes, their textual names, etc.
This property reveals the number of column indexes. Currently this can be either 0, 1, or 2. In an edit table, it can be only 0 or 1 (i.e., either there is a column index or there isn't). In a result table that uses a comparison index, there will be 2 column indexes. When there is a comparison index, but the column pivoter is set to nothing, this property returns 2, but
Nothing (in VB) or
null (in C++, C#).
Note: in future releases, it is possible that the pivot may permit more than two column indexes.
if tab.NumColumnIndexes>0 then ...
This property was introduced in ADE 5.0. It is unavailable in releases prior to that.
Enable comment auto-refresher