PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US

  • Sort Item
  • Sorting a view on several items
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
HSortView (Function)
In French: HTrieVue
ODBCNot available with this kind of connection
Warning
From version 20, the SQL views and the materialized views are available.
The views handled by this function correspond to the former mechanism of views. They do not correspond to SQL views or to materialized views.
Sorts a HFSQL view by creating an index on a view item.
Versions 18 and later
Universal Windows 10 App This function is now available in Windows Store apps mode.
New in version 18
Universal Windows 10 App This function is now available in Windows Store apps mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Versions 21 and later
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Versions 22 and later
iPhone/iPad This function is now available for the iPhone/iPad applications.
New in version 22
iPhone/iPad This function is now available for the iPhone/iPad applications.
iPhone/iPad This function is now available for the iPhone/iPad applications.
Example
HSortView(ViewCustomer84, "City,Name")
Syntax
<Result> = HSortView([<View Name> [, <Sort Item>]])
<Result>: Boolean
  • True if the view was sorted,
  • False otherwise. HError returns more details about the problem.
<View Name>: Optional character string (with or without quotes)
Name of view used. If this name is not specified, HSortView handles the last view used by the last function for HFSQL management (starting with the letter H).
<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, HSortView 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.
Remarks

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 QueriesWindows MobileAjaxUser code (UMC)HFSQLHFSQL 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 TableSort.
Caution: This solution can only be used for the data files in HFSQL Classic or Client/Server format.
Components
WINDEVWEBDEV - Server codeReports and Queries wd230hf.dll
Windows Mobile wp230hf.dll
Linux wd230hf.so
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment