Operating Condition
Syntax: SET TOLERANCE value
Default: 0
SET TOLERANCE sets the tolerance for comparisons between numbers with REAL and DOUBLE data types. The default tolerance of 0 means that the match must be exact to six digits of accuracy for REAL numbers and to 15 digits of accuracy for DOUBLE numbers. R:BASE stores the setting with the database.
The following command specifies a tolerance of .1 when testing column values. If the tolerance is .1 and the WHERE clause specifies colname = 100, then values between 99.9 and 100.1 are valid. If you set the tolerance to one, the values between 99 and 101 are valid.
SET TOLERANCE .1