Filemaker Pro 8.5 Educational Maintenance T3 TJ083LL/A User Manual
Product codes
TJ083LL/A
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.
will store a timestamp in the calculation field whenever FieldB or FieldC changes.
EvaluationError
Format
EvaluationError(expression)
Parameter
expression - any calculation
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.
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
, or a
containing text, a number, date, time, timestamp or container.
Data type returned
number