|
|
|
|
|
|
|
|
|
|
- Sort item
- Sorting a view on several items
<Source>.SortView (Function) In french: <Source>.TrieVue
 Not available with this kind of connection
Sorts an HFSQL view by creating an index on a view item. ViewCustomer84.SortView("City,Name")
Syntax
<Result> = <Source>.SortView([<Sort item>])
<Result>: Boolean - True if the view was sorted,
- False otherwise. HError returns more details about the problem.
<Source>: Source type 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 sorting is first applied according to the first sorting criterion, then according to the second, ... The sorting order applied is as follows: in ascending order, "a" < "u" < "é". 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.).
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|