Interface options are accessible under Options menu (mainly in Options | Environment... menu) and some of them are accessible also in context menus, which are activated by right-clicking on the object(s) that the options are related to.
|Allow only one instance||If the option is on, then only one application instance can exist at a time. When the application is already started, and you will try to start another instance, it fails, then the previous instance is activated, and command line data (if any) will be redirected to the first instance.|
|Show tasks on startup||Set this option to show Tasks dialog each time the application starts.|
|Automatically check for new version||Set this option to allow the application to automatically check for existing of newer Database Tour version. Internet connection is required.|
|Default character set||Specify the char set for newly created text objects in reports and for printing tables or table structure.|
|Maximum database history count||Specify the maximum count of entries in the list of registered databases. When the database count in the list exceeds this value, then the oldest database is removed from the list and the new one is added.|
|When long operation ends|
|Beep||Beep sound after long operations (e.g. after arithmetic calculating etc.).|
|Move to top||Database Tour is moved to stay over all other applications after long operations (e.g. after arithmetic calculating etc.).|
|Copying tables to clipboard|
|With column titles||
If this option is on, then the column titles are also included when copying data to clipboard.
If this option is on, then the contents of MEMO fields (long text) will be also included, when copying. This sometimes may cause the problems when pasting the data (for example, if MEMO data contains carriage return characters etc.).
|Tables||Table view options|
|Buttons||Button view options|
Data View (in tables)
|Show column hints||Specify whether the hint should appear for column titles. The hint consists of the field name and field type.|
|Show data hints||Specify whether the hint should appear for data cells, if the data does not fit within cell. The hint contains the data cell text.|
|Null values||Specify text and text color to highlight the null values. If the text not specified, the corresponding cell remains empty.|
|Dates||Specify conditional formatting for Date and DateTime values|
|Numbers||Specify formatting and conditional formatting for numeric values|
|Text||Specify conditional formatting for text / string values|
|Graphic||Specify view for graphic data|
|Boolean||Specify view for boolean (logical) data|
|Long Text||Specify view for Memo (long text) data|
|Show system objects||This option concerns server databases with system objects (tables, procedures etc.) inside database. If this option is on, then you can see also system objects in the objects' lists.|
|Allow edit tables after opening||If this option is on, the application will always try to open table data for editing. If it fails, or the option is off, then application opens table data in READ ONLY mode.|
|Always show deleted records||This option concerns unpacked dBase/FoxPro tables (BDE connections only). Check this option to always see previously deleted records in such tables (deleted records is highlighted by gray font). If the option is off, you still can temporarily (while the table is open) show those records by choosing Table | Show Deleted Records.|
|Use editable queries, if possible||Editable ("live") queries allow to edit result data set, returning by the SELECT query (you should also use only one physical table for it and should not use aggregate functions in the SQL expression).
If the option is on and the application cannot open a query for editing, or the option is off, then application opens a query in READ ONLY mode.
If you changed this option while query is opened, then you must reopen it to take effect of these changes.
|Asynchronous query execution||Asynchronous execution means ability to run more than one query at the same time (you open several SQL windows and run a query from each of them) or work with the application interface while query (queries) still executing. When this option is off, you need to wait for completing the query in order to work with the application interface or run another query. Please note that if this option is on, the application uses more operating memory.|
|Trim trailing spaces||Specify either to trim trailing spaces and control characters when working with data aware controls (e.g. grids). This option affects only char and varchar data.|
|Use server output||Specify either to use server output (FD connections only). Server output is supported by several DBMS (e.g. Oracle). Note: for some DBMS, using server output may require additional server round trips.|
|Fetch size||For datasets, specifies the count of records to fetch at a single fetch operation (FD connections only). This option affects the dataset opening time and the speed of exporting or reporting. Try to play with it to find the optimal performance for your task.|
|Table filtering options|
|Case sensitive||If this option is on, then the case of symbols is taken into consideration in filtering. This option does not work for ADO connections.|
|Partial compare||If this option is on, partial comparison of strings is allowed in filtering. For example, if the filter is first_name='Da*', then only those records, where first_name field value begins at Da, will be shown in the table grid. Meaningful for text fields only. This option does not work for ADO connections.|
|Quick search options|
|Case sensitive||If this option is on, then the case of symbols is taken into consideration in quick search. Meaningful for text fields only. This option does not work for ADO connections.|
|Partial compare||If this option is on, partial comparison of strings is allowed in quick search. The search is executed to the first text that begins with searched text. Meaningful for text fields only. This option does not work for ADO connections.|
|Without Autocommit||If this option is on, all database changes are done inside transaction, until the user explicitly terminates it by commit or rollback. Please note, that not all databases support transactions and, thus, this mode.|
|Autocommit and manual transactions||If this option is on, each successful database change is committed immediately without ability to rollback. But it is possible to change this behavior by starting transactions manually (if the current database supports this) using the corresponding buttons or menu items from main window.|
|Field names completion||After you entered a table name followed by a period in an SQL editor the list of the table field names will be displayed. You can select the field name to be automatically pasted in SQL text.|
|SQL completion||When you type the first word in SQL editor, the word is automatically completed when it begins as one of the basic SQL keywords. Initial SQL text appears in blank SQL editor when it receives input focus.|
|Clear SQL text after query execution||If this option is on, then SQL text in SQL editor will be cleared every time the query successfully executed. Anyway, that text can be accessed by Previous SQL button.|
|Show query results on a separate page||If this option is on, then SQL query results are shown on a separate Result page of SQL window. Otherwise, they are shown on Edit page, below SQL Editor window.|
|Show line numbers||Turns on/off showing line numbers in SQL editor.|
|Maximum SQL history capacity||Specify the maximum count of SQL statements of executed queries, which the application should keep for each SQL window.|
|Initial SQL text||Initial SQL text appears in blank SQL editor when it receives focus. This works only if SQL completion option is set.|
|Font and Color||Background color, font and SQL syntax highlighting settings|
|Report auto-creating options||Report for selected data set is automatically created when first time report builder or preview loading.
Width and order of report objects depend on the width and order of data grid columns before report creating.
Report builder allows you to edit the created report.
|Schema||Default report style schema. It can be changed anyway in report builder.|
|Create objects only within visible page area||If the option is on then only those objects will be automatically created, which fit in page area.
This recommended if you work with tables, which have many fields, and your computer memory too small.
|Automatically create 'dataset_sum()' expression for float fields||Each time the report is created, the 'dataset_sum()' expression will be automatically generated for each numeric field in the report Totals band.|
|Automatically create 'report_file_name' expression||Each time the report is created, the 'report_file_name' expression will be automatically generated in the Page Footer band. In the case, when report template was loaded from the file or saved to file, it shows the report template file name when previewing or printing the report.|
|Default title||Each time the report is automatically filled, the report title is automatically created. You may specify either it should be a standard title (text like TableName) or your own expression.|
|See File Associations|
|Closing data source||If this option is on, a confirmation appears when user closes active database.|
|Quick reconnection||If this option is on, a confirmation appears when user tries to log as another user by double-clicking User line from database properties on General page.|
|Auto-adjusting column widths||If this option is on, a confirmation appears when user double-clicks the right edge of the data grid column title to adjust its width by the column values. Adjusting the column width requires analyzing all records in the dataset, so it can take some time.|
|Saving SQL text||If this option is on, and the SQL text was changed in SQL editor, but not saved yet, a saving prompt appears when the database is closing.|
|Creating schema for text table||If this option is on, and the user tries to open text table without the schema of field definitions, a prompt appears asking whether to create the schema.|
|Committing / Rolling back transaction||If this option is on, a confirmation appears when user tries to commit or rollback the active transaction using the corresponding buttons or menu items from main window.|
Other (available in Options menu)
|Language||Language of the application interface and help files.|
|Status line||if this option is on, then the status line of the main window will be shown.|