Download User Manual - Tinovimba G. Motsi

Chapter 5: Finding Information
The Advanced Search Utility, shown in the diagram below, allows you to execute queries
on the database for as long as those queries do not seek to modify data. This utility will
allow you to find any information you may want from the database provided you know
the SQL required for the query. In addition to knowing the SQL, you will also need to
know the database structure. For information on the database table structure, consult your
database administrator.
The main search window, pictured above, allows you to manage your SQL files by
saving and opening them later. The following is a summary of what the functions
provided under the Tools menu of the main window do.
Menu Item
New Query
Open SQL File
Save SQL File
Save SQL File As
Execute Query
Print SQL
Remarks
Erases the query window allowing you to start working on a new
query.
Opens a previously saved SQL file.
Saves the currently displayed SQL file under its current filename if
it already has one.
Saves the displayed SQL file under a different filename.
Presents the search results for the displayed query.
Prints the displayed SQL file text.
33