TMedTable.IndexName TMedTable

property IndexName: String ;

Description

Set IndexName to define the active index for the table. When IndexName is empty the records are visible in their physical order (the order of growing RecNo record numbers).

You can set IndexName to any order available in default CDX file or in any index files specified on the IndexFiles property. The default CDX file is the one with the same name as table and .CDX extention - it is opened automatically when table is activated.

When IndexName is set to valid order, it determines the sort order of the dataset records visible to the user. To deactivate the index set IndexName to '' (empty string).

When you set IndexName, the fields indexed with the specified index are automatically calculated and available for you via IndexFieldNames property.