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.

When using the Query Explorer, you will be shown the queries in this directory.

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.

If this is blank, AQT will not use Shared Queries.

When using the Query Explorer, files in this directory will be shown in the Shared Queries folder in the tree.

Location of History Files

This specifies the directory where the query, run-procedure, export history and job history 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.

Default directory for Exports

This directory specifies the directory for Export files when an unqualified filename is specified.

This is main used when an export script is run, and an unqualified filename specified. By default, this directory will be the Exports sub-directory of the Location of Saved Queries.

Directory for Disk Cache

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

Location of Batch Jobs

This is the directory where your batch jobs reside. This is used by the Manage Batch Jobs dialog. Batch jobs located in a different directory will not be seen by Manage Batch Jobs.

By default, batch jobs as held in sub-directory batch from the Application Data directory. A number of sample batch jobs are placed in there by the AQT install process.

Application Data directory

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

where:

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

or

%HOMEPATH%\AQT\Queries