DB OPTLOG

DB_OPTLOG

Class

Environment Variables / Symbols

Purpose

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

See Also

SET OPTLOG

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.

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 Database Server, Recital Mirage Server, Recital Terminal Developer