Please enable JavaScript to view this site.

R:BASE 11 Help

Navigation: Command Index > S > SET

ZERO

Scroll Prev Top Next More

Operating Condition

 

Syntax: SET ZERO ON/OFF

 

Default: OFF

 

SET ZERO allows a null to be treated as a zero in a mathematical expression involving INTEGER, NUMERIC, REAL, DOUBLE, CURRENCY, DATE, DATETIME, or TIME data types. With ZERO set on, R:BASE returns a negative number when you subtract an integer from a null. With ZERO set off, the same computation results in a null. R:BASE stores the setting with the database.