ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage properties / HFSQL properties
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
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 through programming.
  • 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("Ascending sort on LastName")
CASE hDecreasing: Info("Descending sort on LastName")
CASE hNotSorted: Info("No sort on LastName")
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:
hDecreasingDescending order
hIncreasingAscending order
hNotSortedItem 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].
WINDEVWEBDEV - Server codeReports and QueriesUniversal Windows 10 AppiPhone/iPadIOS WidgetUser code (UMC)Ajax

Defining the sort direction for an item described through programming 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:
hDecreasingDescending order
hIncreasingAscending order
hNotSortedItem not sorted
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 03/04/2024

Send a report | Local help