Querying the Database for Specific Records

The 'Ad-Hoc Query' dialog gives you the ability to visually filter the DEATH database to only display specific records.  Even though the dialog is capable of sophisticated SQL generation, the dialog is simple to use as it completely hides the filtering and SQL details from you.  All you need to know is what they are looking for.  The dialog does the rest for you!   The following describes the controls on the dialog:   Fields Displays the list of fields that the you can search on   All | Searched If the All Fields tab page is selected, then the Fields listbox displays all fields.  When set to Searched, the Fields listbox  displays only fields where the user has assigned a search value. Field Order If Alphabetic Field Order is selected then the Fields listbox is ordered alphabetically.  If Logical is selected then the fields are displayed in their natural order. View Summary Button Click this button to view a summary of the current search criteria.   New Search Button Click this button to start a brand new search.   By Value Search criteria for currently selected field to be specified by a Field Value. You can clear the Field Value by clicking on the adjacent Clear button.  Specify a search type of Exact Match to find exact matches of the Field Value.  Specify Partial Match at Beginning and Partial Match Anywhere to find partial matches of the Field Value. Enable the Case Sensitive checkbox  to consider case when searching for the Field Value. By Range Search Criteria for currently selected field to be specified by a starting and ending range.  You can clear the starting and ending ranges by clicking on the adjacent Clear buttons.   OK Button Executes the current ad-hoc query and displays the results in the 'Ad-Hoc Query Results' form.   Cancel Button Closes the Ad-Hoc Query Dialog.

[ CONTENTS ]