Page History
These examples illustrate the use of the range of values rule facility:
Example 1
Field being checked:
Name | Type | Len | Dec |
|---|---|---|---|
POSTCD | A | 4 |
|
Range of values:
From Value | To Value | Comments | |
|---|---|---|---|
| '2000' | '2900' | Check post code is in NSW, VIC or QLD. Post code is alpha. |
...
Example 2
Field being checked:
Name | Type | Len | Dec |
|---|---|---|---|
POSTCD | S | 4 | 0 |
...
Range of values:
From Value | To Value | Comments | |
|---|---|---|---|
| 2000 | 2900 | Check post code is in NSW, VIC or QLD. Post code is numeric. |
...
Example 3
Field being checked:
Name | Type | Len | Dec |
|---|---|---|---|
AMOUNT | P | 5 | 2 |
|
Range of values:
From Value | To Value | Comments |
|---|---|---|
0.01 | 999.99 | Check is AMOUNT positive. |
...
Example 4
Field being checked:
Name | Type | Len | Dec |
|---|---|---|---|
AMOUNT | P | 5 | 2 |
|
Range of values:
From Value | To Value | Comments |
|---|---|---|
-999.99 | -0.01 | Check is AMOUNT negative. |
...
Example 5
Field being checked:
Name | Type | Len | Dec |
|---|---|---|---|
PERIOD | A | 2 |
...
Range of values:
From Value | To Value | Comments |
|---|---|---|
*LASTPER | *NEXTPER | Check PERIOD using site defined system variables *LASTPER and *NEXTPER. |