EPUB | CHM | PDF

TMySQLTable.Properties.IndexFieldNames

Top Previous Next

Lists the columns to use as an index for a table.

Syntax:

property IndexFieldNames: String;

Description:

Use IndexFieldNames as an alternative method of specifying the index to use for a table. In IndexFieldNames, specify the name of each column to use as an index for a table. Ordering of column names is significant. Separate names with semicolon.

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

note You can control whether to sort data on client-side or on server-side by using ReopenOnIndexChange property.

See also: IndexName, ReopenOnIndexChange properties