Icon IndexName Property

property IndexName: String

Usage

Use the IndexName property to specify the active index for a table. If the IndexName property is empty (the default), the active index is set to the default order for the table. The default order is the primary key of the table or, if a primary key is not defined for the table, the natural row insertion order for the table. If the IndexName property is set to a valid index name, then that index is used to determine the sort order of rows, otherwise an exception will be raised.

Information The IndexName and IndexFieldNames properties are mutually exclusive. Setting one clears the other.
Image