Identifies a secondary index for the table.
Syntax:
property IndexName: String;
Description:
Use IndexName to specify an alternative index for a table. If IndexName is empty, a table's sort order is based on its default index.
If IndexName contains a valid index name, then that index determines the sort order of records.
IndexFieldNames and IndexName are mutually exclusive. Setting one clears the other.
Example:
This example uses the IndexName property to sort the records in a table on the CustNo and OrderNo fields.
PSQLTable1.Active := False;
// Get the current available indexes
PSQLTable1.IndexDefs.Update;
// Find one which combines Customer Number ('CustNo') and
// Order Number ('OrderNo')
for I := 0 to PSQLTable1.IndexDefs.Count - 1 do
if PSQLTable1.IndexDefs.Items[I].Fields = 'CustNo;OrderNo' then
// Set that index as the current index for the table
PSQLTable1.IndexName := PSQLTable1.IndexDefs.Items[I].Name;
PSQLTable1.Active := True;