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

2.6.3 Code Table Lookup Check Examples

These examples are provided to illustrate the use of the code table lookup rule facility:
Example 1
Column being checked:

Name

Type

Len

Dec

PRODNO

A

10

 

 |
Table details:

Name

Actual Keys

Keys Supplied

Comments

PRODMST

Product number

PRODNO

Check product is in product master

 |
Example 2
Column being checked:

Name

Type

Len

Dec

TAXCDE

A

3

 

 |
Table details:

Name

Actual Keys

Keys Supplied

Comments

TAXTABL

Tax code type

INCOME

Check TAXCDE is a valid income tax code using alpha literal 'INCOME' in the key list.

 

Tax code

TAXCDE

 

 |
Example 3
Column being checked:

Name

Type

Len

Dec

PARTNO

P

7

0

 |
Table details:

Name

Actual Keys

Keys Supplied

Comments

INVENT

Part number Warehouse number

PARTNO

Check PARTNO exists. This is a "partial" key validation check.

 |
Example 4
Column being checked:

Name

Type

Len

Dec

INVNUM

A

8

 

 |
Table details:

Name

Actual Keys

Keys Supplied

Comments

INVNUM

Invoice number

INVNUM

Check INVNUM does not already exist. Reverse default error logic to get ERROR if key match is found, NEXT if key match is NOT found.

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