Home Search

DriveWorks Pro 22
Info: Error Value and Error String (KB23071901)

Send Feedback

Info: Error Value and Error String

This article relates to the following functions:

When checking for an error it is important to understand the difference between an error value and an error string.

Error Value

An error value is returned by DriveWorks as a result of a invalid rule.

Invalid rules are typically caused by:

  • Dividing a number by zero.
  • Declaring a name (variable, constant, table, hierarchical reference, etc.) that no longer exists.
  • Circular references

A typical error value, returned by an invalid rule, can be:

  • #NA!
  • #VALUE!
  • #REF!
  • #NUM!
  • #NAME?
  • #NULL!
  • #CIRCULAR!

Functions that check for an error value are:

Error String

An error string is a string in an expected format.

Error strings are formatted as:

#TEXTSuffix[Optional Details]

Where:

# - The error string must always start with the # (hash) symbol.

TEXT - The error string TEXT must immediately follow the # symbol (no space) and be all uppercase letters (no numbers, spaces or characters).

Suffix - Is either a ! or ? character and must immediately follow the TEXT (no space).

[Optional Details] - Further details about the error string must follow the suffix with a space.

A typical error string can be:

Functions that check for an error string are:


Knowledge Base Article Ref:KB23071901