4D v14.3

LISTBOX SORT COLUMNS

Home

 
4D v14.3
LISTBOX SORT COLUMNS

LISTBOX SORT COLUMNS 


 

LISTBOX SORT COLUMNS ( {* ;} object ; colNum ; order {; colNum2 ; order2 ; ... ; colNumN ; orderN} ) 
Parameter Type   Description
Operator in If specified, object is an object name (string) If omitted, object is a variable
object  Form object in Object name (if * is specified) or Variable (if * is omitted)
colNum  Longint in Column number(s) to sort
order  Operator in ">" to sort in ascending order or "<" to sort in descending order

The LISTBOX SORT COLUMNS command sorts the rows of the list box set in the object and * parameters on the basis of one or more column value(s).

If you pass the optional * parameter, you indicate that the object parameter is an object name (string). If you do not pass this parameter, you indicate that the object parameter is a variable. In this case, you pass a variable reference instead of a string. For more information about object names, refer to the Object Properties section.

In colNum, pass the column number of the column whose values you want to use as the sort criteria. You can use any type of array data, except pictures and pointers.

In order, pass the symbol > or < to indicate the sort order. If order contains the “greater than” symbol (>), the sort order is ascending. If order contains the “less than” symbol (<), the sort oder is descending.

You can define multi-level sorts: to do so, pass as many pairs (colNum;order) as necessary. The sorting level is defined by the position of the parameter in the call.

In conformity with the principle of list box operation, the columns are synchronized which means that the sorting of a column is automatically passed on to all the other columns of the object.

 
PROPERTIES 

Product: 4D
Theme: List Box
Number: 916

 
HISTORY 

Created: 4D 2004
Renamed: 4D v12

 
ARTICLE USAGE

4D Language Reference ( 4D v12.4)
4D Language Reference ( 4D v14 R3)
4D Language Reference ( 4D v14 R2)
4D Language Reference ( 4D v13.5)
4D Language Reference ( 4D v14.3)
4D Language Reference ( 4D v14 R4)

Inherited from : SORT LISTBOX COLUMNS ( 4D v11 SQL Release 6)