Sort Property

Identifies the columns to be sorted, and ascending or descending sort order.

Syntax

[ sValue = ] TDC.Sort

Possible Values

sValue String expression that is the name of one or more semicolon-separated names of columns in the text file. Each name can be optionally prefixed with a minus sign (-) to indicate a descending sort. By default, this property is set to the empty string. If there is no header line that names the columns, they are given default names of Column1, Column2, Column3, and so on. If Sort is set to an empty string (""), no data will be sorted. See the table below for clarification on the ordering of data types.

The property is read/write. The property has no default value.

Remarks

The following table defines the ordering of commonly used data types.

Data type Ascending Descending
Text "a", "b", "c" ... "z" "z", "y", "x" ... "a"
Numeric ... -1, 0, 1, ... ...1, 0, -1...
Date 1/1/1950, 1/1/1990, 1/1/2000 1/1/2000, 1/1/1990, 1/1/1950
Logical False, False, ... , True, True True, True, ..., False, False

The Sort property sorts the data displayed to the users. It can be set in the initial <OBJECT> tag description to cause initial sorting, or the browser script language can set it and sorting will take effect when the Reset method is called.

Text data is sorted case-insensitively.

Applies To

TDC

See Also

Filter, Reset