Database Tour Documentation Contents Index

Options

Top Previous Next
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.
General
Allow only one instance If the option is on, then only one program instance can exist at a time. When the program 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 program starts.
Automatically check for new version Set this option to allow the program to automatically check for existing of newer Database Tour version. Internet connection is required.
Default char 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 history of previously opened databases. When database count in the history 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 programs 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.

Include MEMO

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 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.).

View
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

See also

 Conditional Formatting

Database
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 program will always try to open table data for editing. If it fails, or the option is off, then program 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 will differ from regular records by their font). If the option is not checked, 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). This option works fro BDE connections only.
If the option is on and the program cannot open a query for editing, or the option is not checked, then program 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 program 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 program interface or run another query. Please note that if this option is on, the program uses more operating memory.
Table filter options  
Case sensitive If this option is on, then case of symbols is taken into consideration in filtering (BDE connections only).
Partial compare Partial comparison of strings (BDE connections only).
For example, if the filter is first_name='Da*' and the option is on, then only those records, where first_name field value begins at Da, will be shown in the table grid.
Quick search options  
Case sensitive If this option is on, then case of symbols is taken into consideration in quick search. Meaningful for text fields only. (BDE connections only).
Partial compare Partial comparison of strings in quick search (BDE connections only). Search is executed to the first text that begins with searched text. Meaningful for text fields only.
SQL Editor
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 first word in SQL editor the word is automatically completed when it begins as one of the SQL keywords. Initial SQL text appears in blank SQL editor when it receives 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 program 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
Reports
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 schema (style). 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.
File Associations
See File Associations
Confirmations
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.
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.
Other (available in Options menu)
LanguageLanguage of the program interface and help files.
Status lineif this option is on, then the status line of the main window will be shown.