Use the NumericSort command in a Logic Template to sort results in either ascending or descending order, using a field containing numeric values. The values are assumed to be signed integers or fixed point data with an implied decimal point.

Integer values stored within a numeric field must be greater than -4294967296 and less than 4294967296. Values greater than or equal to 4294967296 will be treated as negative. Fixed point data with 2 implied decimal places must be greater than -42949672.96 and less than 42949672.96. The limits for fixed point data with other than 2 implied decimal places is adjusted in the same way by moving the decimal point.

To execute a Numeric Sort request, use the NumericSort command with three arguments:

NumericSort( rev, fld, pas );

NumericSort Arguments

Access the NumericSort Dialog Box by selecting the Numeric menu item under the Sorting category of the Logic Template editor command menu.

Examples