Result Set (General Tab)
View General - Result Set page
The Result Set page on the General tab of the Preferences window allows you to set preferences for editing data.
Edit data
Auto commit when finished editing (Default = cleared)
Specify to automatically commit the data when editing the data in the data girds.
Batch Run (General Tab)
The Batch Run page of the General tab of the Preferences window allows you to set preferences for the Batch Run.
| Batch Run for Optimization | Description |
|
Automatically start Batch Run after Optimization |
If selected, batch run starts automatically after Optimization. |
| Batch Run for Index Advisor | Description |
|
Automatically start Batch Run after Index Advisor |
If selected, batch run starts automatically after Index Advisor. |
Editor Tab
Editor
The Editor tab of the Preferences window allows you to define the editable panes control and layout.
General
Use tab characters (Default = cleared)
Specify whether to use the tab character (ASCII 9) instead of spaces.
Specify whether the tab aligns with the next non-whitespace character of the previous line.
Bracket pairing (Default = checked)
Specify whether to match the corresponding opening bracket when the ending bracket is typed.
Use lowercase for object name (Default = checked)
Specify whether to use lowercase for database object names or have them displayed in uppercase.
Block cursor for overwrite mode (Default = checked)
Specify whether to use the block cursor when in overwrite mode. Overwrite mode is when text entered at the cursor overwrites the existing text.
Show all characters (Default = cleared)
Specify whether to display all characters including spaces, carriage return and tabs on the screen.
Show gutter (Default = checked)
Specify whether to show a non-editable boarder on the left of the Editor pane.
Width (Default = 34, Range = 1 to 100 pixels)
Specify the gutter width in pixels.
Show line numbers in gutter (Default = checked)
Specify whether to show line numbers in the gutter.
Apply to SQL Worksheet only (Default = checked)
Specify to display the line number in the gutter only in the SQL Worksheet module when the Show line numbers in gutter option is selected. If not selected, the line numbers are displayed in all windows where you can enter and edit SQL text.
Show right margin ((Default = checked)
Specify whether to show a vertical line at the right margin.
Width (Default = 80, Range = 1 to 1000 characters)
Specify the width of the page or the right margin position.
Block indent size (Default = 3, Range = 1 to 20)
Specify the block indent size in characters.
Tab size (Default = 3, Range = 1 to 20)
Specify the character length of a tab.
Editing
Syntax highlight (Default = checked)
Specify whether to use syntax highlight. If selected, it is possible to define the format for the following syntax: reserved word, SQL function, comment, identifier, quoted identifier, string, number, symbol, data type, global variable, local variable, temporary table, system procedure, invalid object, force, difference highlight (for SQL Comparer), text selection, member lookup and argument lookup.
Auto correction (Default = checked)
Specify whether to automatically correct typing errors and abbreviations as characters are typed. Allows the addition, editing and deletion of the auto correction entries. Also allows the specification of the action key that triggers the automatic replacement.
Lookup
Member Lookup (Default = checked)
Specify whether to show the lookup hint for database object members. For example, displays a list column names when a table name or alias name is followed by a period.
Argument Lookup ((Default = checked)
Specify whether to show the argument parameters hint for database functions and procedures. These hints display when the opening bracket is typed.
Delay (Default = 0.75 sec, Range = 0.5 to 1.5 sec)
Specify the delay time before the lookup hint displays.