Query syntax

The syntax of the query used to produce the Find List can be viewed by clicking Edit on the Find List menu bar and clicking SQL.  The syntax may be edited to include a more complicated query not available when using the Gopher FindButton button.  For example, ‘or’ logic, ranges and joined tables may be introduced and the resulting query is only limited by the knowledge of the person constructing the query.  The changed query executes when Edit is clicked on the menu bar and Close SQL is clicked.  A new ‘find list’ is then presented.  Queries that ADD, CHANGE or DELETE records are not allowed and a warning message will be displayed immediately.