User Tools

Site Tools


syntax:operators

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
syntax:operators [2021/01/13 18:36] dmitrysyntax:operators [2021/01/13 18:43] (current) dmitry
Line 63: Line 63:
        
 === The ASSUME operator === === The ASSUME operator ===
-The operator allows creating guarding conditions that must evaluate to TRUE before the expression is evaluated. ASSUME can be used to ensure data quality and integrity right in expressions. Examples:+The operator allows creating guarding conditions that must evaluate to TRUE before the expression is evaluated. ASSUME can be used to ensure data quality and integrity right in expressions. The operator has the following syntax: 
 + 
 +ASSUME //expression// 
 + 
 +ASSUME //expression// OTHERWISE FAIL //expression// 
 + 
 +Examples:
  
    ASSUME [Tax]>=0     ASSUME [Tax]>=0 
Line 78: Line 84:
    ASSUME [Tax]>=0 FAIL "Tax must not be negative"    ASSUME [Tax]>=0 FAIL "Tax must not be negative"
  
-All the operators can be used together. For instance:+ASSUME can be used together with the other operators. For instance:
  
    ASSUME isnumber({Tax Rate}) OTHERWISE FAIL ("Invalid tax rate: " & {Tax Rate})    ASSUME isnumber({Tax Rate}) OTHERWISE FAIL ("Invalid tax rate: " & {Tax Rate})
syntax/operators.txt · Last modified: 2021/01/13 18:43 by dmitry

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki