Query Tab
The <Tools> <Options> command displays a dialog box with the Query tab:
The Query tab can be used to use the following options:
The option "Use Column Description as heading" that can be used if you want to get the column description as heading-text in the Data Grid instead of the column names when you will create a new query. Note that changing this option will not affect existing queries neither existing reports.
If this option is disabled, the column names will be used as heading text for the data grid columns.
If this option is enabled, the column description will be used, if exists. If not, the column names will be used.
The option "Show native SQL" when running a query, a report or a cross-table.
In the Query SQL Tab, ClicknDECiDE Builder displays the internal SQL syntax being always the same, but in fact ClicknDECiDE Builder translates the SQL statement according to the Host database specification.
By using the option "Show native SQL", ClicknDECiDE Builder will display in a window the SQL sent to the Host database, so you can check if necessary why an error is retrieved by the Host database.
You can copy the window content if necessary. It could be useful sometimes to send the native SQL to your Support supplier.
The option "Display the table name to the right of the Alias Name": this option, very useful when importing queries from within DataSelect V6, allows to display to the right of the Alias T1, T2 etc; the corresponding name of the tables in the Query Worksheet, as the Alias T1, T2 etc. are not very understandable.
"Number of Rows in a Data Grid" : from version 5.0 onwards, this option enables the user to limit the number of rows that are displayed in the data grid (50 by default), this is especially useful when working on queries or demonstrations if the user does not need all the records to be returned. This limit does not effect the dataexport or printing, this can only be limited by defining a value in the First Records option in the query(TOP N) properties. If the user modifies the default value, that is 50, then the new value will only be taken into account for new queries created. If the user does not want to limit the number of rows in the data grid, then they can delete this value or replace it by an asterisk.