Versions Compared

Old Version 2

changes.mady.by.user user-cd56b

Saved on

compared with

New Version Current

changes.mady.by.user user-cd56b

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

2.4.2 Range of Values Examples

These examples illustrate the use of the range of values rule facility:

Example 1

Column being checked:

Name

Type

Len

Dec

POSTCD

A

4


...


From Value

To Value

Comments

 
Or
Or

'2000'
'3000'
'4000'

'2900'
'3900'
'4900'

Check post code is in NSW, VIC or QLD. Post code is numeric.

Example 2

Column being checked:

Name

Type

Len

Dec

POSTCD

S

4

0

...


From Value

To Value

Comments

 
Or
Or

2000
3000
4000

2900
3900
4900

Check post code is in NSW, VIC or QLD. Post code is numeric.

Example 3

Column being checked:

Name

Type

Len

Dec

AMOUNT

P

5

2

...

From Value

To Value

Comments

0.01

999.99

Check that AMOUNT is positive.

Example 4

Column being checked:

Name

Type

Len

Dec

AMOUNT

P

5

2

...

From Value

To Value

Comments

-999.99

-0.01

Check that AMOUNT is negative.

Example 5

Column being checked:

Name

Type

Len

Dec

PERIOD

A

2


...