Results Options

Results

• General
  
  Align Results Tabs at the Bottom: Determines whether results tabs are aligned at the top or at the bottom of the results area.
  Use Thousands Separator for Record Count: Indicates whether to use the thousands separator when displaying the record count.


• Script Execution
  
  Stop on error: Stop executing statements after a failed query.


• Data Retrieval
  
  Convert binary to hex: Convert binary data results to hex.
  Maximum BLOB Blocks: Maximum number of 8k blocks to retrieve from BLOB values
  Maximum CLOB Lines: Maximum number of lines to retrieve from CLOB values
  Right trim spaces on ’char’ and ’nchar’ datatypes: Enables the trimming of spaces from the right on ’char’ and ’nchar’ datatypes.


• Syntax Color
  
  Enabled: Determines whether Syntax Coloring is enabled.
  SQL Statements: The color used for SQL Statements.
  SQL Errors: The color used for SQL error messages.


• Status Panel Color
  
  Enabled: Determines whether Message Panel Coloring is enabled.
  Status Panel Errors: Background: The background color used for SQL error messages on the message panel.
  Status Panel Errors: Foreground: The foreground color used for SQL error messages on the message panel.
  Status Panel Warnings: Background: The background color used for SQL warning messages on the message panel.
  Status Panel Warnings: Foreground: The foreground color used for SQL warning messages on the message panel.


• Save Results
  
  Maximum string length saved for Excel Worksheet: The number of characters that can be stored and displayed in a cell formatted as Text


• Text Results
  
  Maximum column length: Maximum length of characters to display per column
  Display SQL Statement: Determines whether the SQL statements are displayed for each query.
  Display column headers: Display Column Headers when outputting text results
  Display query statistics: Determines whether the statistics are displayed for each query. (ALT-SHIFT-R)
  Display warnings: Determines whether the warning messages are displayed
  Display warning headers: Determines whether the warning headers are displayed along with the warning messages.
  Always display ’records affected’ count: The ’records affected’ is always displayed on queries even if ’Display query statistics’ are off.
  Display only the total number of affected records: Displays only the total number of records affected by the query.
  Margin Character Length: Number of spaces to margin the results


• Message Results
  
  Message results type: Determines in what format the message results are displayed (Grid or Text). Auto will choose the format based on the number of query results returned in the script execution.
  Clear message results before execute: Determines whether to clear the message results tab before executing a statement or script.


• Grid Results
  
  Persist sort across execution: Determines whether grid result table retains sorting.
  Persist quick filter across execution: Determines whether grid result table retains quick filter.
  Alternate row colors: Alternate the row colors of the grid results.
  Alternate row foreground: Sets the alternate row foreground color
  Alternate row background: Sets the alternate row backgorund color
  Clipboard Copy as default format: Determines whether Copy to clipboard will copy numeric values as the full value in the default format.
  Pinning: Determines whether grid results can be pinned.
  Auto Pinning: If pinning is enabled, determines whether each newly created grid result is automatically pinned or not. The number value specifies the maximum number of pinned tabs allowed in a single Query Analyzer window. Once the maximum is reached, the oldest Pinned tab will be removed. [-1 = Auto Pinning Disabled]. [0 = Unlimited Pinned Tabs].
  Specify View as Spreadsheet Directory: Determines in what directory spreadsheet will be saved.