Follow-On Topics

Related Topics

# About the Results Tab

The Results tab is used to display the results of the query when testing. The tab is automatically selected and the results displayed when the Execute button is clicked on the Toolbar. The tab contains the following:
|  | Results — contains rows of query results under the columns selected.
|  | Limit sample record count — Specifies whether to limit the number of rows actually fetched from the data source after the query has been executed.
If the option is checked then the number of rows displayed are limited to the number entered in the field or the number of rows returned by the query, whichever is less. If the option is not checked, all of the rows returned by the query is shown. By default this option is checked and the number of rows to be displayed defined within the Database Query (ODBC) global configuration for the connection. | Click the image to view full size.

NOTE:

As binary information cannot be displayed effectively in the tabular results view this is displayed as simply Binary.

The text following the rows field states the total number of rows returned by the query and the number of rows actually displayed. However, some ODBC Drivers do not provide the number of rows returned by the query and therefore in this case only the number of rows displayed are shown.

Copyright © 2018 Quadrant Software B.V. All rights reserved.