Query and Export Data
Choose 'Utilities - Query and Export Data' from the Main Menu.
This will open the 'SQL Data/Export Utility' form.
  • This is essentially a utility designed to extend the capabilities of your system.
  • It is a database Query and Export tool that requires a good knowledge of both this database and of building queries that will dig out data from it.
  • It will export the results of a query to an external text file (.csv format) if required.
  • It can be of use both to you and our technical support team.

Manual Picture 

A query can be saved by clicking on the 'Save Query' button.

Manual Picture 
  • Select a name for the Query that may jog your memory as to what it does later and click the 'Save' button on the file browser box.
  • If you wish to recall the Script later, select it from the Drop Down box shown then click the 'Load Query' Button.
Manual Picture 
  • Click the 'Run Command' button to see the results of the Query.