• Article

Query Options Results (Text Page)

Use this page to specify the options for displaying a query result set in text format. The settings on this page also apply when Results to File is selected.

  • Output format
    By default the output is displayed in columns created by padding the results with spaces. Other options are using commas, tabs, or spaces to separate columns. Select the Custom delimiter check box to specify a different delimiting character in the Custom delimiter box.

  • Custom delimiter
    Specify the character of your choice to separate columns. This option is only available if the Custom delimiter check box is selected in the Output format box.

  • Include column headers in the result set
    Clear this check box if you do not want each column labeled with a column title.

  • Scroll as results are received
    Select this check box to keep the display focus on the most recently returned records at the bottom. Clear this check box to keep the display focus on the first rows received.

  • Right align numeric values
    Select this check box to align numeric values to the right of the column. This can make it easier to review numbers with a fixed number of decimal places.

  • Discard result after query executes
    Frees memory by discarding the query results after the screen display has received them.

  • Display results in a separate tab
    Select this check box to display the result set in a new document window, instead of at the bottom of the query document window.

  • Switch to results tab after the query executes
    Click to automatically set the screen focus to the result set.

  • Maximum number of characters displayed in each column
    This value defaults to 256. Increase this value to display larger result sets without truncation.

  • Reset to Default
    Resets all values on this page to the original default values.

Saving a text result set with headers

To save query results as a text file with headers, select the Include column headers in the result set check box and a delimited output format. Now the report file will contain headers when you click Results to File on the toolbar, or when you right-click any query results, click Save Results As, type a file name, and then click Save.