m m
Technical Support
How to use the OfficeQ  QSQL_QUERYC.EXE  program
(OfficeQ Query Editor)

(We recommend printing this page to use as a reference while running the program)

To run the OfficeQ Query Editor program, select the OfficeQ Query Editor menu item from the DataBlox OfficeQ6 submenu of your Windows start menu.

When the program is run, a large form is displayed that is used to edit and run SQL database queries.

OfficeQ Query Editor (main form)

This form is used to run and/or edit SQL queries. When the form starts, all queries are listed on the left. To run a query, you need to pick the .MDB database file containing data to be queried using the top left box. You also need to pick the query from the list on the left. After you run the query, the data resulting from the query will be placed in a form and displayed. The purpose of this is to very that the query is producing the correct results - you cannot do anything useful with the displayed data.

List of queries

This list contains a row for each query available to run. To run a particular query, you need to make it current by clicking on it in the list - then click Run Current Query to run it.

The queries can be sorted by clicking the field name at the top of each column (such as sTablesUsed or sGroup). To delete a query, click on it in the list - then click Ctrl-Delete. We use these fields to help categorize / sort / maintain the queries. Some of them are likely of dubious value to anyone else!

The individual fields of the listing have the following meanings:

SQL text of query

The upper right box contains the text of the query as it will be submitted to the query runner in the database. Comments (text that is not considered to be part of the query) are allowed - using one of 2 forms:

If a line containing 5 or more dashes is used (such as: ----------------), then that line and any lines following it are considered a comment and are not part of the query.

Any line where the first printable character of the line is a # is considered a comment. Subsequent lines may still be part of the query.


The lower right box contains notes. Any information can be put here.

Queries Subset Form (Advanced)

This form is used to reduce the number of queries shown in the main form. We initially created this for internal use, but some customers also found it useful. It allows showing only queries that match a certain criteria - such as only queries that use the cCustJob table or only queries that contain technical features, such as GroupBy clauses.

List of Queries

Field sName contains the name of the query.

SQL text of query

Upper right box contains the text of the query. Note that the only table queried here is named 'Query'. This is the table that holds the queries.

Field List

Lower right box. This is simply a list of the fields that make up the Query table - with field name, data type, and example of each. It's here to help write queries.