EvaluationError
Returns an error code, if any, from an expression.
Format
EvaluationError ( expression )
Parameters
expression
- any calculation expression
Data type returned
number
Originated in version
7.0
Description
There are two types of errors: syntax and runtime. 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 FileMaker error codes for a list of error codes and messages.
Notes
- The EvaluationError function must enclose the Evaluate function to return any syntax errors.
Example 1
EvaluationError( GetField ( "total" ) + 1 )
returns 102 (Field Missing) when the field total has been deleted or renamed.
Example 2
EvaluationError( Evaluate ( calculationField ) )
returns 1207 (Unbalanced Parenthesis) when calculationField contains abs(-1
with no closing parenthesis.