SORT method
Description
This method allows you to perform a multi-column sort on an EditTable, along with the ability to convert the data to an appropriate format before the sort takes place.
Applies To
EditTable
Syntax
Call Exec_Method ( CtrlEntID, "SORT", SortCriteria, SortOptions )
Parameters
Parameters are as follows.
| Parameter | Description |
|---|---|
| SortCriteria | <0,1> @svm'd list of column numbers to sort by |
| <0,2> @svm'd list of sorting directions/justifications for each column passed in field <0,1>. Available values are: 0 - Descending Left 1 - Ascending Left 2 - Descending Right 3 - Ascending Right |
|
| <0,3> @svm'd list of ICONV patterns used to convert the column data to its internal format before the sort takes place. The default ICONV pattern used for sorting a column is taken from it's VALID property. This means that you can flag a column as a date (e.g. "DE") in the Form Designer, and have it sort properly in a numeric fashion without any extra coding needed. |
|
| SortOptions | <1> If TRUE$ then perform a trim operation before the sort takes place, or FASLSE$ to prevent the trim. If this field is null then the SORTTRIM property is used to decide if a trim operation takes place. |
Returns
Using the SORT method triggers a new event called SORTED.|