Show pageOld revisionsBacklinksBack to top This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong. ====== 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.| guides/programming/programmers_reference_manual/sort.txt Last modified: 2024/06/19 20:20by 127.0.0.1