Skip to main content

SQL Wizard

The SQL Wizard helps you create a valid SQL statement by walking you through the steps required, and also some options, to pull information from your database either for review or to create a report. The information in your SQL database is stored Tables. A table is a set of columns and rows, like a spreadsheet. Fields are the information stored at the intersection of a column and row. The fields are where the information will be pulled from. The SQL Wizard assists you in locating the fields to gather the information, then displays it under the specifications you request.

Note: The SQL statement that it creates can continually be modified by going back into the SQL Wizard provided you have not manually changed the SQL statement created. Any changes made through the SQL Wizard will overwrite any manual changes that you make.

Saving Specifications​

SQL Statements, also called queries, can be saved so they can be modified and regenerated later. They should be stored in a sub-folder of the roomMaster folder, such as the default folder called "SQL Queries". Click here for more information on saving queries.

To save a query after it has been completed, press the Save Specification ... button. Enter a name for the query specification and it will be saved as a .qws file in the folder.

To load a query at a later time to modify it, press the Load Specification ... button. Select the query which you have previously saved and the SQL Wizard will now have all the values when it was last saved. If you make further changes, you must be sure to come back into the SQL Wizard and resave your query.

The first step of the SQL Wizard is to select the Fields in Query.

Information about .SQL versus .QWS

  • .SQL is a readable form (raw text) of an SQL statement saved in the Interactive SQL window. This is a text file which contains a valid SQL query which can be executed without using the SQL Query Wizard.

  • .QWS is a non-readable specification file used internally by the system to Load and Save the information in the SQL Query Wizard Window. This cannot be opened in the Interactive and Embedded SQL windows and can only be opened through the Load Specification button in the SQL Wizard. If you plan on modifying a query written originally using the SQL Query Wizard, you should save the specification in a folder on your computer for future use.

Note: You do not need to save a query (either by SQL or QWS) if you are placing it on a menu in an embedded report if you do not plan on making modifications to it.

Click here for complete information on SQL Syntax and InnQuest SQL Extensions