Syntax: IsValidExpression ( expression )
expressionA text string containing a calculation expression, or a field or expression that returns a text string that contains a calculation expression.
Data type returned: Number
Returns 1 (true) if the expression syntax is correct. Returns 0 (False) if the expression has a syntax error.
The IsValidExpression() function is often used in conjunction with the Evaluate() function to ensure that Evaluate() is passed a valid expression. For instance, if users are allowed to enter a formula into a field called myFormula, and you want to have another field express the results of that formula, you could use the following:
If (IsValidExpression (myFormula); Evaluate (myFormula); "Invalid formula: " & TextColor (myFormula; RBG (255; 0; 0)))
An expression is considered invalid if it contains syntax errors or if any of the referenced fields cannot be found. Errors that might occur only during execution of the expression, such as record access restrictions, are not detected by the IsValidExpression() formula.
IsValidExpression ("Length (SideA)")
Returns 1 (true) as long as there is, in fact, a field named SideA.
IsValidExpression ("Middle (myField; 1)")
Returns 0 (False) because the Middle function requires three parameters to be considered valid syntax.
Returns 1 (true) if the contents of myFormula would be considered a valid calculation expression.
: FileMaker Specifications
FileMaker 8 Product Line
Specifications and Storage Limits
Field Types and Import/Export Formats
: Calculation Functions
Working with Calculations Primer
: Custom Functions
Custom Functions Primer
Useful Custom Functions
: Script Steps
Script Step Reference
: Quick Reference
FileMaker Error Codes
FileMaker Keyboard Shortcuts
FileMaker Network Ports
FileMaker Server Command Line Reference
FileMaker XML Reference
: Other Resources
Where to Go for More Information