How to Define and Execute Queries

Previous Next

Defining a Query

Click the Define icon MR_bmp0049 to enter search criteria for a query. After you have chosen this option, all fields on the current Info Box (and any of its related Info Boxes) will be cleared, awaiting your input. The shortcut key for this action is F2.

Executing a Query

Click the Execute icon MR_bmp0051 to retrieve the data corresponding to your search criteria. Use this icon after you have first used the Define icon  and then entered search criteria. The shortcut key for this action is F3.

Retrieving All Records

Click the All Records icon MR_bmp0048 to retrieve ALL the data that correspond to the current Info Box. This is the equivalent of pressing F2 followed by F3.

Editing a Previous Query

Click the Edit Previous icon MR_bmp0050 to go back to the most recent search criteria you defined for the current Info Box. This is a helpful option if you want to execute a new query for which the search criteria are only slightly different from those of the previous query. You can also edit a previous query instead of having to define an entire new one. The shortcut key for this action is ALT+F2.

Sorting Query Results

You can sort all queried records on the column that is currently selected. This option toggles between ascending and descending order. You cannot sort columns that are based on a LONGRAW or LONG VARBINARY datatype. To sort the records, choose Query, Sort from the menu, or press F10.

Counting Query Results

Before you actually execute your query, you can count how many records it will return. If the number is very high, you might want to refine your query before executing it. To count the records, choose Query, Count from the menu bar, or press F4.

Canceling a Query

Click the End icon MR_bmp0052 to cancel the process of defining a query. The system will then exit Query Mode, and return to insert/edit mode. The keyboard shortcut for this action is F6.