Use the LinearSort command in a Logic Template to sort results from closest to a defined base value to furthest from that value, using a field containing numeric values. The values are sorted using the absolute value of the difference between each value and the defined base value. 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 Linear Sort request, use the LinearSort command with three arguments:

LinearSort( fld, cntr, pas );

LinearSort Arguments

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

Examples