Please enable JavaScript to view this site.

R:BASE 11 Help

Navigation: Command Index > S > SET

TOLERANCE

Scroll Prev Top Next More

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