613-518-1166 info@zimdatabases.com

Developing ZIM Applications

How To Construct a Validation Rule for Numeric Fields

< All Topics

The available pattern symbols for constructing numeric validation rules are

  • digits used to form specific numbers. Numbers indicate value(s) to which the input data must conform.

  • +, used to specify the sign of a number.

  • period used as a decimal point.

The available syntax characters for constructing numeric validation rules are

Denote a range of numbers.

|

Separates alternative numbers or ranges of numbers.

Examples of Numeric Validation Rules

The following table contains examples of numeric validation rules, and the values that can be legal or illegal under those rules:

Validation Rule

Legal Value

Illegal Value

1|2|3|5

1 or 2 or 3 or 5

0 or 4 or 6

10-20

From 10 to 20, inclusive.
10.123 is also legal. (Use DataMask to control the number of decimal places permitted in the field.)

0-9 or 21

10-20|100-200

From 10 to 20, or from 100 to 200, inclusive

0-9 or 21-99 or 201

-30–5|1|1.3-1.7

From -30 to -5, or 1, or from 1.3 to 1.7

-4-0 or 1.8 or 2

 

Was this article helpful?
0 out Of 5 Stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?
Table of Contents