<Source>.SortView (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help / WLanguage / Managing databases / HFSQL / HFSQL functions

Sort item
Sorting a view on several items

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

<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.

Example

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>: 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" < "é".
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.).

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