BE_ValuesSort ( listOfValues {; ascendingBoolean ; type } )

Sorts a value list in alphanumeric order.

Version : 2.1
Version : 3.3 Added the ascending and type parameters.

Parameters :
listOfValues : The list of values to sort.
ascending : defaults to True, False for descending.
type : a number corresponding to the value for different types.  At the moment, only two values are defined : 0 for text and 1 for Numeric.

Result : The sorted list.

In some situations this sort order won't be the same as the order that FileMaker would apply in a sorted field.  Different encoding and "type" arrangements treat values in different ways, so there's no expectation that the BE sort will be the same as the FM one - the technical details into why this is gets really complex as you get into text encoding and storage and values and ....

Have more questions? Submit a request


Please sign in to leave a comment.