Using the dblookup Program 143
For specific information about Access or Excel
Default Values Devices may be assigned default values. If no full match was found for the current device, dblookup looks for default entries defined with star (’*’) as the key attribute values, and assigns the new attributes with the values of the best match (the one with as few stars as possible).
If no match is found for the current device, dblookup does not set any attribute, but waits for a new device to be
Table 19 shows an example of this:
Table 19 | lookup_2 |
|
|
|
|
lookup_2 |
|
|
|
|
|
NL Type | DNS Layer 1 | Country |
IP | Fr | France |
IP | Uk | U.K. |
IP | De | Germany |
IP | * | <unknown> |
* | * | <?> |
|
|
|
■lookup_2 is a general lookup table based on 2 attributes: NL Layer Type and DNS Layer 1. This lookup table sets the value for the Country attribute.
■An IP device called ’www.demon.co.uk’ gets the ’U.K.’ Country attribute;
■An IP device called ’www.yahoo.com’ gets the ’<unknown>’ Country attribute;
■An IPX device gets the ’<?>’ Country attribute.
Access Database The