SortType (Property)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

This content has been translated automatically. Click here to view the French version.

Help / WLanguage / WLanguage properties / HFSQL properties

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

SortType (Property)

In french: TypeTri

The SortType property is used to:

Find out the sort direction defined for an item or for a component of a composite key. This item was defined in the data model editor or programmatically.
Define the sort direction for an item or a component of a composite key (when the item is described through programming).

Example

// Find out the sort direction for the LastName component of the LastNameFirstName composite key
Res is int
Res = Customer.LastNameFirstName[1].SortType
SWITCH Res
	CASE hIncreasing : Info("Sort ascending on Name")
	CASE hDecreasing : Info("Sort descending on Name")
	CASE hNonSorted : Info("No sort on Name")
END

Syntax

Finding out the sort direction defined for an item Hide the details

<Result> = <Data file>.<Item>.SortType

<Result>: Integer constant

Type of sort:
hDecreasing Descending order
hIncreasing Ascending order
hNotSorted Item not sorted

<Data file>: Character string

Name of the data file used.

<Item>: Character string

Name of the item used.
If the item is a component of a composite key, <Item name> corresponds to: <Name of composite key>[<Component index>].
Example: LastNameFirstName[1].

Defining the sort direction for an item described programmatically Hide the details

<Item>.SortType = <Sort direction>

<Item>: Character string

Name of the item used. This name is defined with the Item Description type.
If the item is a component of a composite key, <Item name> corresponds to: <Name of composite key>[<Component index>].
Example: LastNameFirstName[1].

<Sort direction>: Integer constant

Type of sort:
hDecreasing Descending order
hIncreasing Ascending order
hNotSorted Item not sorted