[Overview][Constants][Types][Classes][Procedures and functions][Variables][Index] |
Fields making up the index
Source position: db.pas line 1020
published property TIndexDef.Fields : string |
Fields is a list of fieldnames, separated by semicolons: the fields that make up the index, in case the index is not based on an expression. The list contains the names of all fields, regardless of whether the sort order for a particular field is ascending or descending. The fields should be in the right order, i.e. the first field is sorted on first, and so on.
The TIndexDef.DescFields property can be used to determine the fields in the list that have a descending sort order. The TIndexDef.CaseInsFields property determines which fields are sorted in a case-insensitive manner.
|
Fields in field list that are ordered descending |
|
|
Fields in field list that are ordered case-insensitively |
|
|
Expression that makes up the index values |