PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
  • Use conditions
  • Sorting a browsing Table or TreeView Table control
  • Managing a sorted Table or TreeView Table control
  • Sort on a calculated column
  • Table or Treeview Table control browsed by programming
  • Performing a sort according to the ASCII value
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
Sorts a Table or TreeView Table control on one or more columns (lexicographical sort).
Note: When a control is sorted by <Table>.Sort, the images used to identify the sort direction are not displayed in the columns.
Versions 20 and later
Android This function is now available for Android applications.
iPhone/iPad This function is now available for iPhone/iPad applications.
New in version 20
Android This function is now available for Android applications.
iPhone/iPad This function is now available for iPhone/iPad applications.
Android This function is now available for Android applications.
iPhone/iPad This function is now available for iPhone/iPad applications.
Example
// Sort the "Designation" and "Price" columns in the "TABLE_Product" control
// The "Designation" column is sorted in ascending order
// The "Price" column is sorted in descending order
TABLE_Product.Sort("Designation", "-Price")
Syntax

Sorting a Table or TreeView Table control on one or more columns identified by their name Hide the details

<Result> = <Table control>.Sort(<Name of column 1> [, <Name of column 2> [... [, <Name of column N>]]])
<Result>: Boolean
  • True if the sort was performed,
  • False otherwise.
<Table control>: Control name
Name of control to use. This control can correspond to:
  • a Table control.
  • a TreeView Table control.
<Name of column 1>: Character string with quotes
Name of first column to sort (up to 16 columns). This parameter has the following format:
"[<Direction>]<Column name>"

where:
  • <Direction> (character) indicates the sort direction:
    • "+": ascending sort (by default),
    • "-": descending sort.
  • <Column name> (character string): name of column to sort.
<Name of column 2>: Optional character string with quotes
Name of the second column to sort (up to 16 columns). This parameter has the following format:
"[<Direction>]<Column name>"

where:
  • <Direction> (character) indicates the sort direction:
    • "+": ascending sort (by default),
    • "-": descending sort.
  • <Column name> (character string): name of column to sort.
<Name of column N>: Optional character string with quotes
Name of Nth column to sort (up to 16 columns). This parameter has the following format:
"[<Direction>]<Column name>"

where:
  • <Direction> (character) indicates the sort direction:
    • "+": ascending sort (by default),
    • "-": descending sort.
  • <Column name> (character string): name of column to sort.

Canceling a sort that was previously defined on a memory Table or TreeView Table control Hide the details

<Result> = <Table control>.Sort(<False>)
<Result>: Boolean
  • True if the sort was canceled,
  • False if a problem occurred.
<Table control>: Control name
Name of control to use. This control can correspond to:
  • a memory Table control.
  • a memory TreeView Table control.
<False>: Constant
False: Keyword used to cancel a sort that was previously defined on a memory Table or TreeView Table control.
Remarks

Use conditions

<Table>.Sort can be used on:
  • a memory or browsing control with automatic browse ("Automatic browse" option checked in the "Content" tab of control description). For a browsing control, the sort is performed on a single column.
  • a single-selection or multiselection control.
AndroidiPhone/iPad The TreeView Table control is not available.

Sorting a browsing Table or TreeView Table control

A browsing Table or TreeView Table control will be sorted according to the first specified column (syntax 1 and 2). Caution: the column used for the sort must be linked to a key item in the data file used to browse the control.
Tip: To sort a browsing Table or TreeView Table control with several columns, use a composite key and ..BrowsedItem:
TableName..BrowsedItem = NAMECOMPOSITEKEY
To cancel a sort in a browsing Table or TreeView Table control, all you have to do is assign an empty string to ..BrowsedItem.

Managing a sorted Table or TreeView Table control

Reminder: <Table>.SortedColumn returns the list of sorted columns.

Sort on a calculated column

<Table>.Sort should not be used on the calculated columns. Indeed, these columns are calculated when each row is displayed.
A sort performed by <Table>.Sort on a calculated column will be valid for the rows already displayed in the table.

Table or Treeview Table control browsed by programming

<Table>.Sort does not operate on a control browsed by programming.

Performing a sort according to the ASCII value

A memory zone allows you to perform a sort according to the ASCII value.
Example:
MemCreate("MZ")
MemAdd("ZM", "abc", "abc")
MemAdd("ZM", "ZZZ", "ZZZ")
MemAdd("ZM", "zbc", "zbc")
MemAdd("MZ", "ééébc", "ééébc")
MemAdd("ZM", "AB", "AB")
MemAdd("ZM", "CD", "CD")
MemAdd("MZ", "çabc", "çabc")
MemAdd("ZM", "bbc", "bbc")
MemSort("MZ")
i is int
MemFirst("MZ")
WHILE NOT MemOut("MZ")
i = MemCurrent("ZM")
Trace(MemRetrieve("MZ", i)) // Display in ASCII order
MemNext("MZ")
END
Component : wd240obj.dll
Minimum version required
  • Version 23
This page is also available for…
Comments
Click [Add] to post a comment