Setting Answerset Options
Use the following procedure to control the Answerset and the appearance of data in the Answerset by setting options on the Answerset tab of the Options dialog box.
Additional data options that apply to both the Answerset window and to Exported data can be set on the Data Format tab. See “Setting Data Format Options” on page 121.
To set Answerset options
1 Select Tools > Options.
2 Click the Answerset tab. Table 20 explains each option.
Option |
Description |
Display alternate Answerset rows in color |
Select this item to display colors for alternate rows in the Answerset. Use the color picker to choose a color. The color choices include a Custom tab, a Web tab and a System tab. The default is cleared. |
Open new Answersets in Move Columns Mode |
Selecting this option activates “Move Columns mode” when a new Answerset opens, which allows you to re-arrange the columns by dragging columns to the desired position. The default for Move Columns mode is off. |
Display grid lines in future Answerset columns |
The default value of this option is selected. Gridlines appear when a new Answerset window is created. |
Display 1000 separators in numeric columns |
The default value of this option is selected. |
Display negative numbers in Red |
This option displays negative values in red in the Answer pane. |
Display Column Titles rather than Column Names |
This option allows the Answerset columns to display titles rather than names. The default value of this option is selected. This means the column title is used as the column header when returning data to the Answerset window. If cleared, column names appear. Column titles can be defined at the time a table is created, or as part of a |
Wrap wide headers across 2 lines if the data is narrow |
The default value of this item is selected. This option allows column titles that are wider than the maximum data width in that column to be wrapped across two lines to display narrower columns. If this option is not selected, column titles display on a single line. |
Display Float values using scientific notation |
The default value of this option is cleared. If selected, Float column data displays in scientific notation. For example, 1.234567e04. |
Use default file names for LOB columns |
The default value of this option is cleared. If selected, the file names used for LOB columns are constructed from the column title and a default file type. You are not prompted to enter this information. |
Default file type for BLOB columns |
This file type is used for BLOB columns when the above option is selected. |
Maximum number of answer rows to display |
The default value of this option is 2000. This number is the maximum number of answer rows that are retrieved from the database before you are prompted whether you want to continue retrieving further rows. If you want all remaining rows to be retrieved without further prompts, answer No to the following question: Cancel at <number> rows in accordance with settings? When prompted to continue, all remaining rows are retrieved without any further prompts. |