GetIndex property

Returns an index created by CreateIndex.

Applies to

TableData	ArrData	RsetData	Xdata	XShared
✓	✓

GetIndex returns the entire set of index keys as a 2-dimensional 0-based array. The first dimension represents the index entry, and the second dimension represents the number of the corresponding field in the set of fields which are indexed. So effectively the returned index is the set of unique values of the indexed fields. Any of these sets of keys can be looked up using the Lookup method to return the matching data rows.

TableData and ArrData support indexing to enable records to be easily located. RsetData does not support indexing.