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).
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].
WEBDEV - Server codeAjax

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