| 20% Command group | 20% Flag affected | 20% Reversible | 20% Execute on client | 20% Platform(s) |
|---|---|---|---|---|
| Data files | YES | NO | NO | All |
Close lookup file {lookup-name}
This command closes the lookup file which matches the reference name given in the parameters. Each lookup file is given a reference label when it is opened. In this example it is "City".
If the reference label given in the Open lookup file command is omitted, you can omit the lookup name in the Close lookup file command. If the specified lookup file is closed, the flag is set; if the lookup file doesn't exist, the flag is cleared.
Open lookup file {City,Lookup.df1,fCities}
If flag true
OK message {The city you require is [lookup('City','I',2)]}
End If
Close lookup file {City}