Advanced Query Tool

Display Data

The same window shows table contents or query results.

  • the data in this grid can be printed, sorted, copied (to the clipboard), exported or saved
  • you can move the columns around in this display, or hide them completely
  • F2 shows you the Row Detail for a row

Formatting Data

You have many options for formatting the display. In this example:

  • The results have been grouped by column Color
  • Sub-totals have been calculated
  • The display has been given a Caption
  • The dollar amounts have been formatted as currency amounts
  • A different Style has been applied to the data. You can select between a number of inbuilt styles, or create you own.

Once you have formatted the data as required, you can save the layout and reapply it the next time you display this table.

Link Data

The Link feature allows you to display rows from related tables.

  • AQT will automatically pick up relationships from the database. Alternatively you can define your own user-defined-relationships
  • As you click on a row, the related rows are shown in the bottom pane

Display LOBs

AQT has excellent support for BLOBs and CLOBs. To display a LOB column, AQT will write the BLOBs as a series of files on disk. You can display these in the appropriate external application.

Display XML Data

If you have XML data, AQT's XML Viewer can be used to display the data in an easy to read format.

  Go Home Go to Top

Last reviewed on 17 May 2011   

Copyright 2002-2011 Cardett Associates Ltd. All rights reserved.