FILTER COMMAND GENERATOR 



This portion of the routine allows you to set a filter condition for 

 the particular file you have selected. You may bypass the routine by 

 entering "ALL" for the FIELD input. You may end your input by 

 pressing the return key in the CONNECTION input area. 



PLEASE WAIT. 



Fig. 3-10: The AD-HOC Query Introduction Screen 



Fig. 3-11: A Typical AD-HOC Query Generation Input Screen 



Presently, no error checking is built into the system. Carefully 

 review each input element before confirming the input with <cr>. If 

 however, your AD-HOC query appears in error on previous screens, simply 

 return to the AD-HOC menu and reconstruct the query. 



3.2.5. User-generated Query (unrestricted). 



If you select this choice, you will be presented with a screen 

 prompting you to enter a query condition that may be up to 254 characters 

 long. Although you are limited by the grammatical rules of dBASE III, you 

 may perform some very powerful and complex boolean searches. . .for example, 

 you can search for all streams in Gallatin or Madison County that have 

 value class assignments of 1 for both fisheries and recreation, or you can 

 search for all natural features that are designated as either National 

 Natural Landmarks or Research Natural Areas but do not have a value class 

 of 2. 



as 



Some of the basic rules of dBASE III grammar you'll need to know 

 follows: 



are 



3-9 



