Sort-Types

This property specifies the sorting property of the Grid control columns. Multiple values can be specified enclosed between parentheses. Values are applied to cells, starting from the first. Sort types are represented by single characters.

Valid values are:

-	Not sortable. This is the default.
X	Alphanumeric sorting, case-insensitive
U, L	Alphanumeric sorting, case-sensitive
9, N	Numeric sorting, leading sign and current decimal-point used, all other non-digit characters ignored
I	Integer sorting, leading sign used, all other non-digit ignored
P	Positive integer sorting, all non-digit characters ignored
D, E	Date sorting. Assumes three integer fields separated by one or more non-digit characters. Integers are year, month and day. Two-digit years less than 30 are treated as year 20xx while other two-digit years are treated as year 19xx.   The default ordering of the fields is month, day, year if the current decimal point character is a point or period (.), otherwise the default ordering is day, month, year. You can explicitly specify the ordering by appending a three-character string enclosed by parenthesis, using Y, M and D to represent the year, month and day respectively. For example, D(DMY) is date order, with the date being in day-month-year order.   Only MDY, DMY and YMD are currently valid. Invalid format strings have undefined results.

Any value other than the ones described above prevents sorting on the column.

The default sort ordering is ascending. You may specify the default order as descending by appending a caret (^) to the Sort-Types value. For example “X^” specifies a descending alphanumeric sort. Optional elements may be specified in any order. For example ”D^(MDY)” and “D(MDY)^” both specify a descending date field using the month-day-year ordering.

Ascending/descending order only determines the sort order when the user first clicks on the column. After that, the user can reverse the ordering by clicking again.

The user requests the sort by clicking on the column header. The Column-Headings style must be set in order to be sorted by the user.

This property overrides the Sortable-Columns style. If both are set, the runtime behaves like if only Sort-Types was set.

 

Example - Define a grid where column 1 and 3 are sortable

screen section. ...   03 screen-1-gr-1 Grid      line 5.7      column 3.1      size 34.6 cells       lines 15.5 cells       help-id 5040      id 1      event procedure screen-1-gr-1-evt-proc      boxed      column-headings      hscroll      heading-color 200      heading-divider-color 12      cursor-frame-width 3      display-columns (1, 10, 20, 30)      sort-types ("X", "-", "X", "-")      num-rows 5      .