Current Record and Total Record Counts

While in the Result window, SQLWizard retrieves enough records to show a complete page in the window. Each time you scroll or page to display more records, you are commanding SQLWizard to retrieve the additional records. There are two major advantages to this approach:

Note:

You can limit the total number of records that a query can retrieve by setting the Max Rows To Retrieve option in the Current Query Options dialog box or through the Options utility.

Notice that as you move the cursor to different records in a result, SQLWizard updates the RECORD n OF m message on the status bar at the bottom of the screen. The first number in this message is the current record number and the second is the total number of records in the query result. If the total number of records is unknown, you will see a ? in place of the record count. If you need to know the actual record count, you can request that the system perform a count by selecting the Count command on the Record menu.

To find the total record count for the result:

  1. Open the Record menu.
  2. Click the Count command.

    SQLWizard displays the current record number (relative to the retrieved set of records) and the total number of records in the result on the status bar.

    Note:

    Performing a count causes the SQLWizard to retrieve all of the records in the result. For some results, such as joins on large tables, this could take quite some time. This is why SQLWizard does not automatically perform a count for you.