Segment options

The segment options specify how the key will handle the contents of the selected key segment.

Descending   This option specifies the order in which the records will be sorted. If the option is marked, records will be sorted in order of highest value to lowest (3, 2, 1 or c, b, a). If the option isn’t marked, records will be sorted lowest to highest (1, 2, 3 or a, b, c).

Ignore Case   This option is available only if the selected segment is a string field. The Ignore Case option specifies whether case determines how the table will be sorted. If the option is marked, the case of the data in the key segment won’t affect the sorting process. If the option isn’t marked, uppercase characters will have a lower value than lowercase characters for sorting purposes. This option does not apply for tables that use the SQL database type.

The following table shows how a set of last names would be sorted, depending upon how the Ignore Case option is marked.

[spacer]

Ignore Case marked

Ignore Case not marked

adams

Beaulieu

Beaulieu

JOHNSON

douglas

Jones

hagelle

Simpson

JOHNSON

adams

Jones

douglas

Simpson

hagelle



Documentation Feedback