Query Layout tab

Use the tools to build a query.

SQL tab

View and edit the SQL.

Results tab

Set parameter types and values and view results after Execute Query.

I/O tab

View results of I/O for the query.

File Menu

Load SQL Query

Load a previously saved SQL query file.

Save SQL Query
Save as SQL Query

Save query as an SQL Query file.

Buttons

Check Query (Alt+C)

Checks the syntax of the query shown on the SQL tab without executing. An error message will provide details of problems.

Execute Query (Alt+X)

Executes the query shown on the SQL tab and shows the results on the Results tab.

Clear Results (Alt+E)

Clears the data shown on the Results tab. You must clear the results to make changes in the Query Layout tab or SQL tab.

Print (Ctrl+P)

From the Query Layout tab and the Results tab, prints the Query Results.

Note: You need to click Execute Query before you print Query Results, to generate results to be printed.

From the SQL tab, prints the SQL Query.

Accept (F9)

Accepts the query and returns to Report Designer. If you accept a query when the Results tab is:

• Blank - the query is run each time you execute the report for test purposes.
• Populated - test runs may be based on the saved results. This is useful when you are working on the design of a report and not changing the data reported on.

Cancel (Esc)

Closes SQL Query Builder and returns to Report Designer without saving changes to the query.