Category: Logical

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.

IsValidExpression (myFormula)

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

Calculation Signatures

Calculation Functions

: Custom Functions

Custom Functions Primer

Useful Custom Functions

: Script Steps

Scripting Primer

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

FileMaker 8 Functions and Scripts Desk Reference
FileMaker 8 Functions and Scripts Desk Reference
ISBN: 0789735113
EAN: 2147483647
Year: 2004
Pages: 352 © 2008-2020.
If you may any questions please contact us: