SortType (Property)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

InfoThumbnailGeneration

OperationLogDirectory

Password

PasswordProtected

PersistedCalculatedItem

RepeatableReadSupported

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HFSQL properties

SortType (Property)

In french: TypeTri

..SortType 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 by programming.
Define the sort direction for an item or for a component of a composite key (when the item is described by programming).

Versions 17 and later

This property is now available for iPhone/iPad applications.

New in version 17

This property is now available for iPhone/iPad applications.

Versions 18 and later

This property is now available in Windows Store Apps mode.

New in version 18

This property is now available in Windows Store Apps mode.

Versions 21 and later

This property is now available in Universal Windows 10 App mode.

New in version 21

This property is now available in Universal Windows 10 App mode.

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("Ascending sort on Name")
CASE hDecreasing: Info("Descending sort on Name")
CASE hNotSorted: 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:
hIncreasing Ascending order
hDecreasing Descending order
hNotSorted Item not sorted

<Data file>: Character string (with or without quotes)

Name of data file used.

<Item>: Character string (with or without quotes)

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

Defining the sort direction for an item described by programming Hide the details

<Item>..SortType = <Sort direction>

<Item>: Character string (with or without quotes)

Name of item used. This name was defined by the Item description type.
If the item corresponds to a component of a composite key, <Item name> corresponds to: <Name of composite key>[<Component subscript>].
Example: LastNameFirstName[1].

<Sort direction>: Integer constant

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