Previous Topic

Next Topic

Book Contents

Book Index

Options - File Locations

These options specify the directories where relevant files reside. In all cases clicking on Change allows you to change the directory. Clicking on Default will reset the directory to its default location.

Default directory for files created by AQT

AQT creates a number of files while it is running. These are:

By default, these files are created in sub-directory workfiles of the AQT Application Data directory (this directory is discussed later).

If you change this directory, you should move any existing files to the new location. AQT can do this for you automatically when you change this directory and click on OK.

Location of Config files

This specifies where the config files are located. Database Types and Config Files describes the config files. By default this directory is sub-directory cfg of the AQT install directory.

Location of saved queries

This specifies the default directory for queries to be saved to and retrieved from. This is used in the Save Query window.

By default, these files are created in the sub-directory queries of the AQT Application Data directory (discussed later). If you wish to share your queries with another user, you may wish to change this directory to another location.

Location of shared queries

This specifies the directory containing queries which are shared amongst members of your workgroup. This would typically be a directory on a shared server.

Location of History Files

This specifies the directory where the query and run-procedure History files are held. If this is blank, the directory used is the Default Directory for files created by AQT.

If you change this directory, you should move your history files to this new location. This change comes into effect immediately and AQT will write into the new directory the next time it runs a query.

Location of Layout Files

If this is specified, Layout files will always be held in this directory.

If this option is not specfied, the Layout files will be held in the queries directory (for table layouts) or the same directory as the query (for query layouts). This is discussed further in Saving / Retrieving the display layout.

If you change this directory, it is your responsibility to move your existing layout files from their current locations to this directory.

Location of Report Styles

This specifies the location of Report Styles, as used by the Generate Report function of the Data Display window.

A number of Report Styles are delivered as part of AQT, and are held in sub-directory ReportStyles of the AQT install directory. Windows security can prevent modification to this directory, which can interfere with your amending or adding reports. In this case, locating the report styles in another directory can be useful.

If you change this directory, it is your responsibility to move the existing report styles from their current location to this new directory.

Directory for Disk Cache

This is the directory where the Disk Cache files are held.

Application Data directory

Files created by AQT are held in your Application Data directory. This is:


Note: this directory is also given by the APPDATA environment variable.

Using Windows Environment Variables

You can use Windows Environment variables in the file locations. Example:

%APPDATA%\Advanced Query Tool\Queries