Home | Sign in | English EN

  • 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.).
Reports and QueriesUser code (UMC)AjaxHFSQLHFSQL 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: wd260hf.dll
Minimum version required
  • Version 25
This page is also available for…
Click [Add] to post a comment