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.
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.
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.
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.
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.
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.
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.
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.
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.
This is the directory where the Disk Cache files are held.
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.
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.
You can use Windows Environment variables in the file locations. Example:
%APPDATA%\Advanced Query Tool\Queries
or
%HOMEPATH%\AQT\Queries