[ |../../index.htm#lansa/l4wtgu02_0125.htm]
You are here:

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

 

 |
Range of values:

 

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

 |
Range of values:

 

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

 |
Range of values:

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

 |
Range of values:

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

 

 |
Range of values:

From Value

To Value

Comments

*LASTPER

*NEXTPER

Check PERIOD using site defined system variables *LASTPER and *NEXTPER.

 |
[ |../../index.htm#lansa/l4wtgu02_0125.htm]