oDataTable.Sort(SortType, vCol)| SortType | (Long) Sort type: 0 - ascending (01..89..AB..YZ..ab..yz) 1 - descending (zy..ba..ZY..BA..98..10) |
|---|---|
| vCol | (Variant) Specifies the column where rows have to be sorted. It must be of the String type or the integer. If is of the String type, then it is the name of the column. If is integer >=0, then it is the column index (zero-based index). If is integer -2, then it means the last column. |
The sort is convenient only in the column with values of the same data type (only numbers, only String, only logical or time values).
Sorting of columns of the String type is processed with respect to the language localisation.
If there are more rows (>1000), then the sort can take non-negligible time.
If the request to sort is, for example, by the column 1 and if the values equal, then by the column 2 - then this can be realized by two calling of the Sort method: at first to sort by the column 2 and then sort by the column 1.
var oDataTable = pMe.Pm("/DataTable");
oDataTable.Sort(0, 5);