Controll functions allows the definition of conditions to other functions or expressions.
| Controll functions |
Syntax |
|
NZ
|
Returnes a blank string or a defined value of a optional type, if the first argument is null.
|
Nz(number value ;[number null_value])
Value: Value which has to be checked for null.
Null value: Returned value if value is null.
|
IIF
|
Returnes a blank string or a defined value of a optional type, if the first
argument is null.
Example: IIf([amount] > 1000; "much"; "less")
|
IIf(boolean condition; variant true-value; variant false-value)
Condition: An expression with a boolean result or a boolean constant.
True-value: Returned value if condition is true.
False-value: Returned value if condition is false.
|
SWITCH
|
Returnes the first value from a value list which value or expression outcomes true .
Example: Switch(false; "first"; 1=2; "second"; true; "third")
returns the value third .
oder:
Switch(
[Ort] = "Madrid"; "Palacio Real";
[Ort] = "Berlin"; "Brandenburger Tor";
[Ort] = "Turin"; "Mole Antonelliana";
Wahr; "no sight"
)
Checks for the value of a component and returns the adapted string. Applies no one of the named
conditions, then the last condition will be used.
|
Switch(boolean condition; variant value ;[boolean condition; variant value] ;[boolean ...; variant ...])
Bedingung: An expression with a boolean result or a boolean constant.
Wert: Returned value if condition is true.
|
ISNULL
-
ISTNULL
|
Checks the argument for null. The returned value is always a constant with the true
or false.
|
IsNull(variant value)
Wert: A optional value or an optional object which has to be checked for null.
|
ISDATE
|
Checks if the argument describes a date value. The returned value is always a constant with the value true or false.
|
IsDate(variant value)
Value: A optional value or an optional object.
|
ISTIME
|
Checks if the argument describes a time value. The returned value is always a constant with the value true or false.
|
IsDate(variant value)
Value: A optional value or an optional object.
|
ISNUMERIC
|
Checks if the argument can describe a number. The returned value is always a constant with the value true or false.
The returned value is also true if it is a string, which can be converted to a number.
|
IsNumeric(number value)
Value: A optional value Wert or a optional object.
|
functions