1. Administrator's Guide
  2. Managing Formulas
  3. Formula Evaluation
  4. Formula Syntax Checks

Formula Syntax Checks

Formula syntax is verified for the following before a formula is saved:

  • Function names are correct.

  • Property names are correct.

  • An equal number of open and close parentheses are present.

  • The actual number of parameters is at least the expected number of parameters for each function

Functions such as Concat can take any number of parameters. The parameter count validation verifies that the actual number of parameters is equal to or greater than the expected number of parameters. Thus too many parameters do not generate an error, but too few parameters do.

The syntax validation does not evaluate the formula, therefore errors may occur if invalid constants are entered. For example: IntToStr(ABC,3) passes the syntax validation, but generates an error in the Oracle Data Relationship Management application. You must evaluate each formula to avoid this type of error prior to saving.