PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK

WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
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 18 and later
Universal Windows 10 App This property is now available in Windows Store Apps mode.
New in version 18
Universal Windows 10 App This property is now available in Windows Store Apps mode.
Universal Windows 10 App This property is now available in Windows Store Apps mode.
Versions 21 and later
Universal Windows 10 App This property is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This property is now available in Universal Windows 10 App mode.
Universal Windows 10 App 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:
hIncreasingAscending order
hDecreasingDescending order
hNotSortedItem 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].
WINDEVUniversal Windows 10 AppUser code (UMC)

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:
hIncreasingAscending order
hDecreasingDescending order
hNotSortedItem not sorted
See also
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment