Adding Query:

Click “ADD QUERY” button and fill in the Query into the window:

Click “OK”

Double-Click on the New Query and it will be executed.

The Result will be displayed in a new window like this:

Export the result into the Comma-Separated text file or MS Excel Spreadsheet file by selecting “Export” menu.

Displaying Pre-Configured Table:

Modify “tables.xml” file to create a list of tables, which will be displayed as well as the help information on the structure of the tables.

tables.xml file has the following structure:

Some Help Goes Here.

Change the Name of the Tag and put some Help information between tags and it will be displayed when table is selected in the List:

Please make sure that TableName exists on the target Database you are connecting to.

EXAMPLE of Displaying Help.

Select one of the tables in the list and click “Help”.

Put Field names between Tags separated by commas and when clicked “View Table” button, those fields will be Selected against the table and displayed.

Please Note that in order to export to MS Excel format, MS Office Has to be installed on the Client System.