[Overview][Constants][Types][Classes][Procedures and functions][Variables][Index] | Reference for unit 'DB' (#fcl)

# TIndexDef.Fields

Fields making up the index

## Declaration

Source position: db.pas line 1057

`published property TIndexDef.Fields : string read FFields write FFields;`

## Description

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.

## See also

TIndexDef.DescFields |  | Fields in field list that are ordered descending
TIndexDef.CaseInsFields |  | Fields in field list that are ordered case-insensitively
TIndexDef.Expression |  | Expression that makes up the index values