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 17 and later
iPhone/iPad This property is now available for the iPhone/iPad applications.
New in version 17
iPhone/iPad This property is now available for the iPhone/iPad applications.
iPhone/iPad This property is now available for the iPhone/iPad applications.
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> = <File Name>.<Item Name>..SortType
<Result>: Integer constant
Type of sort:
hIncreasingAscending order
hDecreasingDescending order
hNotSortedItem not sorted
<File Name>: Character string (with or without quotes)
Name of data file used.
<Item Name>: 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].
WINDEVWEBDEV - Server codeReports and QueriesiPhone/iPadWindows MobileUniversal Windows 10 AppAjaxUser code (UMC)

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

<Item Name>..SortType = <Sort Direction>
<Item Name>: 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