Search... for records

Back Up

Installation

Introduction

Getting Started
   First Steps
   Record Navigation
   Tree Views
   Search... For

Operations Centre

Subscriptions

Training Records

Dive Logs

Equipment

Resource Databases

Customising DiveData

The Search option is powerful but potentially difficult, because it allows you to enter complex queries. Becase these queries are ad hoc it is quite possible to enter meaningless criteria, and fail to retrieve any records (e.g. "Surname less than 42")

 

The search dialog works by letting you build up complex queries from simple ones. A simple query contains three parts; a fieldname, an operator and a value. Clicking the dropdown arrow in the Field combo box displays a picklist of all the fields in the current database table (some of which can be quite cryptic!) Choose the field on which you want to search.

The second part is a list of operators, such as "Greater Than", "Equals", "Begins with" etc. Note that numeric values should be compared with "Equals" but text values should use "Like".

The third part is the value to which you want to compare the field. Clicking the dropdown arrow displays a list of all the unique values of this field in the database. You can either select from the list or type directly into the text part of the control.

Once you have built your simple query press the "Add" button to add it to the frame in the bottom half of the dialog. You can then either press the Find button to search for the first record meeting your criterion or add another criterion, joining the two with "And" or "Or".

Keep pressing the Find Next button to move to subsequent records, until you get a message saying that no more records meet your criteria.

 

© 1999 Energico Associates Ltd
Last Updated: 18 December, 1999