Functions Reference

Chapter 8
|
Logical functions 131
The dependent parameter can also be useful in other cases. For example,
Evaluate(“Get(CurrentTimeStamp)”, [FieldB, FieldC])
will store a timestamp in the calculation field whenever FieldB or FieldC changes.
EvaluationError
Format
EvaluationError(expression)
Parameter
expression - any calculation expression
Data type returned
number
Description
Returns an error code, if any, from expression. There are two types of errors: syntax
errors and runtime errors. A syntax error indicates an invalid calculation. A runtime error,
such as Field missing or Record missing, occurs when the calculation currently being run
is valid but cannot properly execute. See Get(LastError) function, page 87, for a list of
error codes and messages.
Note The EvaluationError function must enclose the Evaluate function to return any
syntax errors.
Examples
EvaluationError(calculationField) returns 102 (Field Missing) when
calculationField contains total + 1 and the field total has been deleted or renamed.
EvaluationError(Evaluate(calculationField)) returns 1207 (Unbalanced
Parenthesis) when calculationField contains abs(-1 with no closing parenthesis.
GetAsBoolean
Format
GetAsBoolean(data)
Parameter
data - any text, number, date, time, timestamp or container expression, or a field
containing text, a number, date, time, timestamp or container.
Data type returned
number