Extended sorting

M!Table provides the following extended sort features:

  • Sort multiple columns
  • Specify the sort data type ( e.g. make a numeric sort on a string column ) or use a custom sort value and/or string
  • Sort case insensitive
  • Sort only a range of rows
  • Sort only a range of row levels
  • Sort only rows that are descendant of a parent row
  • Exclude single rows from sorting
  • Get the last sort definition
  • Make a tree sort ( restore the row hierarchy )

Functions
MTblSort
MTblSortRange
MTblSortEx

MTblGetLastSortDef

MTblSortTree

Messages
MTM_QuerySortString
MTM_QuerySortValue
MTM_RowsSwapped

Row Flags
MTBL_ROW_NO_SORT

Table Flags
MTBL_FLAG_SORT_KEEP_ROWMERGE
MTBL_FLAG_SORT_RESTORE_TREE


Hints and tips

General
MTblSort and MTblSortRange are subsets of MTblSortEx.

Recommended table properties
It's recommended to set "Discardable" to "No" and "Max Rows In Memory" to an appropriate value.

Fetching missing rows
When a table is sorted, M!Table fetches all missing rows in the specified range.

Created with the Personal Edition of HelpNDoc: iPhone web sites made easy