Help / WLanguage / Managing databases / HFSQL / HFSQL functions
  • Sort item
  • Sorting a view on several items
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WindowsLinuxPHPWEBDEV - Browser code
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Stored procedures
<Source>.SortView (Function)
In french: <Source>.TrieVue
ODBCNot available with this kind of connection
Sorts an HFSQL view by creating an index on a view item.
<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
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.).
WINDEVWEBDEV - Server codeReports and QueriesUser code (UMC)AjaxHFSQL ClassicHFSQL Client/Server

Sorting a view on several items

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

Last update: 10/26/2023

Send a report | Local help