SortOption (Property)

the text columns found in Table controls,
the text columns found in TreeView Table controls,
the List Box and ListView controls,
the Combo Box controls,
Versions 15 and later
the attributes of Looper controls,
New in version 15
the attributes of Looper controls,
the attributes of Looper controls,
Versions 16 and later
the images, the clickable images and the thumbnails with automatic scroll.
New in version 16
the images, the clickable images and the thumbnails with automatic scroll.
the images, the clickable images and the thumbnails with automatic scroll.

This property can only be used on the "memory" controls. It is not available for the "browsing" controls. These sort options can be defined in the window editor or in the page editor, in the "Details" tab of control description.

Example

// Sorts a list while respecting the numeric order
LIST_Turnover..SortOption = ccRespectNumeric

Syntax

Finding out the sort options used Hide the details

<Sort options> = <Control name>..SortOption

<Sort options>: Integer constant

Sort option currently applied:
ccLexicographicOrder Sort the character strings in lexicographical order (for example, the 'é' character is found between the 'e' and 'f' characters)
ccNormal
(Default value) Standard comparison, similar to the = operator
ccRespectNumeric Sort while taking into account the numeric values inside the strings (in this case, "10" comes after "9").
ccIgnoreAccent Sort while ignoring the accented characters
ccIgnoreCase Sort while ignoring the case (uppercase/lowercase characters)
ccIgnoreSpace Sort while ignoring the space characters found before and after the character strings
ccIgnorePunctuationAndSpace Sort while ignoring the punctuation and the space characters (see the Notes for more details)
sortDefault Sort while ignoring the case and the accented characters and while taking the space characters into account
sortWithoutFunctionGxxx Sort while ignoring the elements such as gImage, gLink, ... By default, these elements are taken into account by the sort.

<Control name>: Character string (with or without quotes)

Name of control to use.

Modifying the sort options Hide the details

<Control name>..SortOption = <Sort options>

<Control name>: Character string (with or without quotes)

Name of control to use.

<Sort options>: Combination of Integer constants

Sort option that will be applied to the control:
ccLexicographicOrder Sort the character strings in lexicographical order (for example, the 'é' character is found between the 'e' and 'f' characters)
ccNormal
(Default value) Standard comparison, similar to the = operator
ccRespectNumeric Sort while taking into account the numeric values inside the strings (in this case, "10" comes after "9").
ccIgnoreAccent Sort while ignoring the accented characters
ccIgnoreCase Sort while ignoring the case (uppercase/lowercase characters)
ccIgnoreSpace Sort while ignoring the space characters found before and after the character strings
ccIgnorePunctuationAndSpace Sort while ignoring the punctuation and the space characters (see the Notes for more details)
sortDefault (cannot be combined) Sort while ignoring the case and the accented characters and while taking the space characters into account
sortWithoutFunctionGxxx Sort while ignoring the elements such as gImage, gLink, ... By default, these elements are taken into account by the sort.

Remarks

Taking the sort order into account

For the List Box and Combo Box controls, the sort order specified by ..SortOption is immediately taken into account.
For the columns found in the tables or in the treeview tables, TableSort must be called in order for the specified sort order to be taken into account. For example:

COL_Name..SortOption = ccLexicographicOrder
TableSort(TABLE_Name, "+COL_Name")

Characters taken into account for the punctuation and the spaces

The characters taken into account for the punctuation and the spaces are supplied by the system. To get the list of these characters, write the following WLanguage code:

s is string
FOR i = 0 TO 255
IF Charact(i) <> StringFormat(Charact(i), ccIgnorePunctuationAndSpace) THEN
s += Charact(i)
END
END
Info(s)
ToClipboard(s)