Options - General

Background Colour

Allows you to select the colour used in many of the AQT windows.

Grid Color

If you have a 256-color display, you will notice that some of the colors in the grids look "grainy" and make the text hard to read. To circumvent this, switch this option to Compatible with 256 color display. AQT will use a simpler set of colors for grids; they won't be as pleasing to the eye, but they will be easier to read.

Alternate Selection Color

By default, when cells are selected in a grid they will be displayed as black on gray. When this option is selected, selected cells will be white-on-blue (which is more inline with the color scheme used in other windows controls).

When this option is in effect, you cannot select a two-color grid display. This results in some cells being displayed as white-on-white, which makes the cell contents invisible.

Debug Mode

This is used to collect diagnostic information for the AQT developers. You would switch this on if you are having a problem and are collecting diagnostic information.

The debugging information is written to a file (aqtdebug.txt in the install directory). There will be a small performance impact while this option is switched on. View can be used to look at this debug file.

Prompt before Closing AQT

With this option selected, if you still have a database connection open AQT will prompt you before it closes.

Having this option selected is often useful to prevent inadvertently closing AQT (which can happen if you click on the wrong close button).

Close AQT when all windows are closed

This option specifies whether you want AQT to terminate when all the windows are closed.

Captions for Data Display icons in the Window-list bar

When a Data Display window is opened, a button is created in the AQT window-list bar. The caption for this button is taken from the table name (if you are displaying a table), query name (if you are running a query), or some other descriptive text. The options here govern, to some extent, what text is used here:

• maximum characters in caption. This specifies how many characters will be used in the caption. A large value here will allow a longer, more descriptive, caption to be used, however the button will be wider.
• caption is formed from. By default, when displaying a table, the caption will be schemaname.tablename - for instance DBA.EMPLOYEE). You may not be interested in seeing the schema name here. In this case, select Table name only. The caption will be (for instance) EMPLOYEE.

Most options relating to the window-list bar can be obtained by right-clicking the window-list bar.

Show user name as part of database name

When this option is select, the user name will be included as part of the database caption. So instead of the database name appearing as (for instance) Oracle, it will appear as Oracle (system).

This option is useful if you are have multiple connections to the same database, each with a different userid.

For Oracle, identify database by Server Name

When you sign onto a database, by default the database will be identified within AQT by the Datasource name (this is the name shown on the Signon window).

When this option is select, the database will instead be identified by the Oracle Server name.