Tools

Control Toolbar Buttons Action
This option allows you to choose the reaction on clicking buttons on the control panel. If you choose Create New Object, then the new database object is created on clicking one of these buttons, if you choose Show Last Object, then the last viewed database object is opened for editing.

   Start transaction automatically after data is changed
If this option is enabled, the transaction automatically starts after data is changed.

   Disable transaction confirmation
This option allows you to not to confirm each transaction carried out.

Default action
Defines the default transaction action: commit or rollback.


   Show only connected databases in drop-down menu
Displays only connected databases in the drop-down menus of such tools as: QueryBuilder, SQL Script, etc.

   Request live results for queries
If you work with live data and want to protect query results from accidental editing, you should switch off this option

DB Explorer

Show hosts in DB Explorer
Shows/hides database hosts in the DB Explorer tree.

Show Table Subobjects
Shows/hides table subobjects (fields and indices) in the DB Explorer tree.

Recent windows count
Defines the number of objects displayed on the Recent tab of the DB Explorer.

Tables' Details in SQL Assistant
Switches the SQL Assistant mode for displaying table fields, indices or table status (Table Properties).

SQL Editor

   Fetch all
If this option is checked, all the records according to the query are extracted from the tables, otherwise - only those, displayed on Results tab in the SQL Editor window.

   Explain query
If this option is checked, query plan is displayed at the bottom of the SQL Editor window.

   Show results for each query
Displays the Results tab after executing each query in the SQL Editor.

SQL Script

   Abort Script on Error
If this option is checked, script execution aborts when an error occurs.

   Rollback on Abort
This option is available only if Abort Script on Error is checked. This option evokes automatic rollback on script execution abort.

Query Builder

   Select condition row
Displays the selected condition in different row on the Criteria and Grouping Criteria tabs of the Query Builder.

   Drag field name
Displays the dragged field name in the Builder area.

   Hide selection when inactive
Hides the selection when Query Builder is inactive.

   Show field types in hints
Displays the field type next to the field in the table box.

Visible Tabs
These options specify which Query Builder tabs are available and which are not. Check boxes to make the appropriate tabs visible.

Script Format
These options specify the case formatting of keywords and functions in query text on the Edit tab. As is saves the original case, Uppercase sets all the keywords/functions to upper case, Lowercase sets all the keywords/functions to lower case, and First upper sets the first letters of all keywords/functions to upper case.

Style
These options specify how different Query Builder objects look like - 3D, flat, etc.

Color Palette
These options define colors of different Query Builder elements: condition row, active caption, table client area, etc. Click an item to select a color for the appropriate Query Builder element.

Reports

Default Paper Size
Defines the default paper size for the reports.

Table

   Always Open the Fields Tab
Always opens the Fields tab by default on activating the Table Editor.

   Show Object Explorer
Enables/disables showing the object explorer tree by default at the left of each Table Editor.

See also:

DB Explorer SQL Editor SQL Script Editor Visual Query Builder