RAD Studio |  |

Specifying an Index with IndexName
See Also
Collapse All

Use the IndexName property to cause an index to be active. Once active, an index determines the order of records in the dataset. (It can also be used as the basis for a master-detail link, an index-based search, or index-based filtering.)

To activate an index, set the IndexName property to the name of the index. In some database systems, primary indexes do not have names. To activate one of these indexes, set IndexName to a blank string.

At design-time, you can select an index from a list of available indexes by clicking the property's ellipsis button in the Object Inspector. At runtime set IndexName using a String literal or variable. You can obtain a list of available indexes by calling the GetIndexNames method.

The following code sets the index for CustomersTable to CustDescending:

Copy Code

    CustomersTable.IndexName := 'CustDescending';

Copy Code

    CustomersTable->IndexName = "CustDescending";

For information on specifying dBASE non-production index files and dBASE III PLUS-style .NDX files, see Specifying a dBASE index file

See Also

Obtaining Information About Indexes

Creating an Index with IndexFieldNames

Copyright(C) 2009 Embarcadero Technologies, Inc. All Rights Reserved.
What do you think about this topic? Send feedback!