Search

The Search statement is used for including or excluding fields when using the search function.

Syntax:  

Search Include *fieldlist

Search Exclude *fieldlist

 

You can use several Search statements to refine your selection of fields to include. The statements are evaluated from top to bottom.

Arguments:  

Argument Description
*fieldlist A comma separated list of the fields to include or exclude from searches. Using * as field list indicates all fields. The wildcard characters * and ? are allowed in field names. Quoting of field names may be necessary when wildcards are used.

Example:  

Search Include *;

Include all fields in searches.

Search Exclude '*ID';

 Exclude all fields ending with ID from searches.

Search Include ProductID;

 Include the field ProductID in searches.

The combined result of these three statements, in this sequence, is that all fields ending with ID except ProductID are excluded from searches.