8.1 Workspace Reference (修訂 #12)

      The table shortcut toolbar is a very useful item for people who wish to query the same tables often.
    You can simple right-click on a table object and select the [add shortcut to toolbar] to add that
    table's short cut to the toolbar.  Once you have a table shortcut you may right click on that shortcut
    and change the shortcut properties. For example: if you create many queries on the same tables and wish
    to always start with you could change the properties of shortcut [Key Binding] to "U"
    and property to checked. Everytime you click U your current query will be
    cleared and you will be starting a new query with .
      The toolbar settings are saved even when query builder is closed, so your table toolbar will still have
    the quick table refrence when you re-open the query builder.

      Loads an existing Query Builder Document into the query builder.  If the current database connection of
    the query builder is not that of the document, query builder will load the connection information from
    the document.  This is the only method to change database connections in the query builder without reloading
    the query builder.

      After creating a query you may save it as a .xqb object.  The object contains local refrences pointer
    information used by Query builder to discover database and schema information, but does not actually
    save any database specific information.  So if you wish to save an .xqb file and reload it on a diffrent
    machine you will need to make sure that the local refrence pointer information is correct.  You may do
    this by opening the file in a text editor and checking the .
      If you only wish to save the sql statement you may use the save sql as option.  This will save the sql
    statement of the object to a .sql file in a text format.  You can not load a .sql file into query builder.

   Save Results:
      You may also save the result set of the query to file in many diffrent very useful formats. The encoding
    and platform can be specified or left as default to the current machine but may also be changed if you
    plan on sending the file to be used by someone in a diffrent country or operating system.  The results type
    can be of the following : Grid Results, Pivot Grid Results, Text Results, Client Statististics or Explain Plan;
    with the following data formats: Html, Excel, XML, Insert or Delimited
      Grid results will give you just the data from the sql statement in the chosen format.  Html, Excel, XML
    and Delimited are basic formats for data display options.  The Insert format is an interesting way of saving
    the results.  This option can be used to save scripts that would create a new table containing the results as
    its data or to create scripts that would insert the results into an existing table.  You will need to make
    sure and specify the schema and table name and type of line execution plan accordingly with the type of
    database you are working with.  If you do not the scripts created will not work properly.
      Pivot Grid Results works very simular to Grid results unless you save it to excel.  Saving to excel will
    also save its pivot grid information if any was created.
      Text Results will create a file with the complete server text output. including the sql statement, column
    headers, query data results, any errors that would accur from the sql or exceptions generate the application.
    you can uncheck the [ ] include sql statement if you don't wish to have the sql statement saved.
      Client Statistics will give you specific statistics on the object run.  Including the count and type of
    queries executed; rows affected; transactions; time required to execute server and client side; wait times,
    etc...
      Explain Plan does not currently process anything in query builder.

      The Group By column allows the user to give grouping information for columns or to apply data
    aggregate functions to a column.  Column functions compute, from a group of rows, a single value for a
    designated column or expression. This provides the capability to aggregate data, thereby enabling you to
    perform statistical calculations across many rows with one SQL statement.