Home | Sign in | English UK
New WINDEV, WEBDEV, WINDEV Mobile 25 feature!
  • Sort item
  • Sorting a view on several items
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WindowsLinuxPHPWEBDEV - Browser code
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Stored procedures
<Source>.SortView (Function)
In french: <Source>.TrieVue
ODBCNot available with this kind of connection
Sorts a HFSQL view by creating an index on a view item.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
<Result> = <Source>.SortView([<Sort item>])
<Result>: Boolean
  • True if the view was sorted,
  • False otherwise. HError returns more details about the problem.
<Source>: Type of Source
Name of view used.
<Sort item>: Optional character string (with quotes)
List of sort items found in the view. The items are separated by a comma or CR. The sort order can be specified by prefixing the string with "+" (ascending) or "-" (descending). By default, the sort is performed in ascending order ("+"). If this parameter is not specified, <Source>.SortView refers to the last item of the view used.
The possible format for this list are:
  • "[+/-]<1st item> [, [+/-]<2nd item> ]"
  • "[+/-]<1st item> [CR [+/-]<2nd item> ]"
The sort is performed according to the first sort item, then according to the second one, ... The following sort order is applied:: for an ascending sort, "a" < "u" < "é".
Hyper File 5.5 A single sort item must be specified in this parameter.

Sort item

An index can be created on any item of the view. If the item was a key item in the data file, the order relationship that was given to it in the analysis is used (sensitivity to the case, to the punctuation, etc.).
WEBDEV - Server codeAjaxHFSQLHFSQL Client/Server

Sorting a view on several items

To sort a view on several items, you have the ability to display the view records in a memory Table control and to use <Table>.Sort.
Caution: This solution can only be used for the data files in HFSQL Classic or Client/Server format.
Component : wd250hf.dll
Minimum version required
  • Version 25
This page is also available for…
Click [Add] to post a comment