EvaluationError
 
Purpose 
Returns an error code, if any, from an expression.
Format 
EvaluationError(expression)
Parameters 
expression - any calculation expression
Data type returned 
number
Originated in 
FileMaker Pro 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 Pro error codes 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.
Related topics 
Functions reference (category list)
Functions reference (alphabetical list)
About formulas
About functions
Defining calculation fields
Using operators in formulas
Was this topic helpful? Send feedback.