Searching

Executing search

To execute a search you need to have a form open, active (e.g. click on the results window title bar and make it light blue), and any qualifiers specified. Once you have done that, click the Search button in the button bar.

This will connect to the database and query it. While the query is active, the SV Icon in the upper right will animate.

Examining results

Once a query finishes the records will be retrieved back to StarView. You can move through the records using the Prev, Scan, and Next buttons.  The Prev and Next buttons move back and forward 1 record. The Scan buttons scan forward and backward through records.  The Stop button is used to stop scans through the records.

You will be able to tell which record is being displayed by looking at the results form's lower right hand corner

Here we see that we are on record 1.  There are ... records.  This tells you that, in the interest of bandwidth, StarView has not retrieved all matching records. By Scanning forward until the last record this becomes

telling us that there are 184 records total matching our query.

Notice that scanning is quick initially, but the results form does not update for each record in the scan. This is because, by default, result forms are in a No Update mode.  By clicking on No Update the form changes to Update (as does the buttons text). Now scanning is slower but each record is displayed as you scan through the records.

Copying results into qualifications

Right clicking on any results field produces a popup menu.  On all results popup menus is the option of copying the value to the clipboard (the Copy item).

Once can then move to the qualifications table and right click on a qualifier to get its popup menu

From here you can paste the copied result into the qualification, or append it into the qualifier (joined by the ; character as an AND).  This is the simplest way of using results to drive searches.