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


Fields making up the index


Source position: db.pas line 1057

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


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



Fields in field list that are ordered descending



Fields in field list that are ordered case-insensitively



Expression that makes up the index values

Documentation generated on: May 14 2021