Page
|
|
|
Next Page |
|
| Contents > Functions reference (alphabetical list) > Logical functions > EvaluationError function |
|
|
| EvaluationError function |
| 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 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 |
|
|
| Contents > Functions reference (alphabetical list) > Logical functions > EvaluationError function |
|
|
Next Page |
|