[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 1020

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


Documentation generated on: Sep 28 2017