The Options dialog
In the Options dialog, the user may set some global parameters for the Office-QB application as a whole. There are two tabs in this dialog (see Figure 10 and 11 for more details).
· The Query tab, which contains the Query Timeout and the Editable query results controls,
· The HTML/MIME tab, which contains some options for the HTML/MIME output format,
Figure 10. Showing the Query tab of the Options dialog |
Figure 11. The HTML/MIME tab of the Options dialog |
The Query
Timeout parameter controls the timeout delay interval for a query
execution. That is, if a query takes a longer time then specified to return
records, then
Office-QB will stop the execution and report a query timeout expire error
message. For most purposes a value of 120 seconds is enough time to execute
queries with millions of records.
The Editable query
results check-box controls the edit capability of
Office-QB in
the
Result
tab-view. To be able to edit the result of queries you must have this
check-box checked.
The
Include description
section check-box of the
HTML/MIME
tab controls the inclusion of an empty Description section in the HTML
output. This is specially useful in the case of e-mail output, where the user
may enter some comments about the query result.
The Include SQL
command text check-box controls the inclusion of the SQL command text for
the query, above the query result output.
The Include ELS-logo
in the footnotes check-box controls the inclusion of the
Office-QB
logo as a footnote at the bottom of the query result output.