SortList |
Top Previous Next |
×V4.3Ø
Syntax: SortList <List Name> <Column to Sort> {ASCENDING | DESCENDING} [<Column Type>] Where: <List Name> is the user defined name that is assigned to the list. <Column to Sort> is a number or variable containing a numeric value. <Column Type> is one of the following: Currency, Date, Number, String
Description: The command sorts an existing list defined by <List Name> on a specific column <Column to Sort> to either Ascending or Descending order. The optional parameter <Column Type> can be used to specify if the column should be treated differently than the default value, Number. During the sort, if you have specified Currency and a Date is present in the column, EMUE will automatically sort the list as String due to the mismatch in type.
Sample 1: The following example sorts a list called SmallBalance on the 8th column in a descending order. SortList SmallBalance 8 DESCENDING
Sample 2: The following example sorts a list called Patients on the 2nd column in an ascending order. SortList Patients 2 ASCENDING
Sample 3: The following example sorts a list called BadDebt on the 3rd column in a descending order as Currency. SortList BadDebt 3 DESCENDING Currency
See Also: |