Difference between revisions of "DB OPTLOG"

From Recital Documentation Wiki
Jump to: navigation, search
 
Line 1: Line 1:
=DB_OPTLOG=
 
 
 
==Class==
 
Environment Variables / Symbols
 
 
 
 
==Purpose==
 
==Purpose==
 
Used to determine whether the evaluation of logical expressions should be optimized
 
Used to determine whether the evaluation of logical expressions should be optimized
Line 15: Line 8:
  
 
==Description==
 
==Description==
The DB_OPTLOG environment variable / symbol is used to determine whether the evaluation of logical expressions should be optimized.  If DB_OPTLOG is set to "OFF" or "NO" or "FALSE", evaluating a logical expression causes the entire expression to be evaluated.  If DB_OPTLOG is set to "ON" or "YES" or "TRUE", the evaluation of the logical expression is optimized.  The optimization causes the evaluation to stop as soon as the result of the evaluation is known.
+
The DB_OPTLOG environment variable is used to determine whether the evaluation of logical expressions should be optimized.  If DB_OPTLOG is set to "OFF" or "NO" or "FALSE", evaluating a logical expression causes the entire expression to be evaluated.  If DB_OPTLOG is set to "ON" or "YES" or "TRUE", the evaluation of the logical expression is optimized.  The optimization causes the evaluation to stop as soon as the result of the evaluation is known.
  
 
For example:
 
For example:
Line 35: Line 28:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital, Recital Server
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Configuration]]
 
[[Category:Configuration]]
 
[[Category:Environment Variables|OPTLOG]]
 
[[Category:Environment Variables|OPTLOG]]

Latest revision as of 09:48, 4 March 2010

Purpose

Used to determine whether the evaluation of logical expressions should be optimized


See Also

SET OPTLOG


Description

The DB_OPTLOG environment variable is used to determine whether the evaluation of logical expressions should be optimized. If DB_OPTLOG is set to "OFF" or "NO" or "FALSE", evaluating a logical expression causes the entire expression to be evaluated. If DB_OPTLOG is set to "ON" or "YES" or "TRUE", the evaluation of the logical expression is optimized. The optimization causes the evaluation to stop as soon as the result of the evaluation is known.

For example:

If DB_OPTLOG is switched off, the following command will cause an error, assuming no function called ’crash’ exists.

? .F. and crash()

If DB_OPTLOG is switched on, no error will occur, since the evaluation process will stop after the .F. has been evaluated. At this point, the result of the expression can only be .F. (false).

If DB_OPTLOG is switched off, the following command will cause an error, assuming no function called ’crash’ exists.

? .T. or crash()

If DB_OPTLOG is switched on, no error will occur, since the evaluation process will stop after the .T. has been evaluated. At this point, the result of the expression can only be .T. (true).


Products

Recital, Recital Server