Reference > Functions reference > Logical functions > EvaluationError
 
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 error codes for a list of error codes and messages.
Notes 
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