Versions Compared

Key

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

[ Image Removed |../../index.htm#lansa/l4wtgu02_0115.htm]
You are here:

...

2.3.2 List Examples

These examples are provided to illustrate the use of the list of values rule facility:

Example 1

Column being checked:

Name

Type

Len

Dec

STATE

A

3

 

...


List of values:

List Of Values

Comments

'NSW'
'QLD'
'VIC'

Check for valid Australian state mnemonic.

...

Example 2

Column being checked:

Name

Type

Len

Dec

NAME

A

7

 


 |
List  List of values:

List Of Values

Comments

*BLANKS

A blank name is an error. Reverse the default error logic to get ERROR if in list, NEXT if not in list.

...

Example 3

Column being checked:

Name

Type

Len

Dec

COMPNO

P

1

0

 |
List  List of values:  

List Of Values

Comments

1
2
3

Company number must be 1, 2 or 3.

...

Example 4

Column being checked:

Name

Type

Len

Dec

YEAR

A

2

 


 |
List of values:

List Of Values

Comments

*LASTYEAR
*THISYEAR
*NEXTYEAR

Year must equal one of the site defined system variables *LASTYEAR, *THISYEAR or *NEXTYEAR

...