Difference between revisions of "SET OPTLOG"

From Recital Documentation Wiki
Jump to: navigation, search
Line 1: Line 1:
=SET OPTLOG=
 
 
 
 
==Class==
 
==Class==
 
Environment
 
Environment
Line 15: Line 12:
  
 
==See Also==
 
==See Also==
[[DB_OPTLOG]]
+
[[DB_OPTLOG]], [[Logical Operators]]
  
  
 
==Description==
 
==Description==
The SET OPTLOG command is used to specify whether logical expression optimization should take place or not.
+
The SET OPTLOG command is used to specify whether logical expression optimization should take place or not.  If SET OPTLOG is OFF, evaluating a logical expression causes the entire expression to be evaluated. If SET OPTLOG is ON, 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.  
  
 
==Example==
 
==Example==
<code lang="recital" numbers="n">
+
<code lang="recital">
 
// No error, even if crash() function does not exist
 
// No error, even if crash() function does not exist
 
set optlog on
 
set optlog on
Line 37: Line 34:
 
// Gives error if crash() function does not exist
 
// Gives error if crash() function does not exist
 
set optlog off
 
set optlog off
? .T. or crash()</code>
+
? .T. or crash()
 +
</code>
 +
 
  
 
==Products==
 
==Products==

Revision as of 08:50, 17 April 2009

Class

Environment


Purpose

To specify whether logical expression optimization should take place


Syntax

SET OPTLOG ON | OFF


See Also

DB_OPTLOG, Logical Operators


Description

The SET OPTLOG command is used to specify whether logical expression optimization should take place or not. If SET OPTLOG is OFF, evaluating a logical expression causes the entire expression to be evaluated. If SET OPTLOG is ON, 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.

Example

// No error, even if crash() function does not exist
set optlog on
? .F. and crash()
 
// Gives error if crash() function does not exist
set optlog off
? .F. and crash()
 
// No error, even if crash() function does not exist
set optlog on
? .T. or crash()
 
// Gives error if crash() function does not exist
set optlog off
? .T. or crash()


Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer