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
Timeout parameter controls the timeout delay interval for a query
execution. That is, if a query takes a longer time then specified to return
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.
section check-box of the
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.