Logical Functions
Logical functions allow comparative tests to be evaluated and return differing results based on those comparisons. They also allow you to work with variables.
|
Syntax |
Data Type Returned |
|---|---|
|
Case ( test1; result1 {; test2; result2; defaultResult...} ) |
Text, Number, Date, Time, Timestamp, Container |
|
Choose ( test; result0 {; result1; result2...} ) |
Text, Number, Date, Time, Timestamp, Container |
|
Evaluate ( expression {; [ field1; field2; ...]} ) |
Text, Number, Date, Time, Timestamp, Container |
|
EvaluationError ( expression ) |
Number |
|
GetAsBoolean ( data ) |
Number |
|
GetField ( fieldName ) |
Text, Number, Date, Time, Timestamp, Container |
|
GetNthRecord ( fieldName; recordNumber ) |
Text, Number, Date, Time, Timestamp, Container |
|
If ( test; result1; result2 ) |
Text, Number, Date, Time, Timestamp, Container |
|
IsEmpty ( expression ) |
Number |
|
IsValid ( expression ) |
Number |
|
IsValidExpression ( expression ) |
Number |
|
Let ( {[} var1=expression1 {; var2=expression2 ...]}; calculation ) |
Text, Number, Date, Time, Timestamp, Container |
|
Lookup ( sourceField {; failExpression }) |
Text, Number, Date, Time, Timestamp, Container |
|
LookupNext ( sourceField; lower/higher Flag ) |
Text, Number, Date, Time, Timestamp, Container |
|
Quote ( text ) |
Text |