SQL Editor Preferences


Option
Description
Default
Appearance
Print margin column
This value defines the column position of the print margin.
80
Synchronize outline selection on cursor move
If this option is turned on, each cursor move in the editor will update the selection of the corresponding element in the outline view if that view is visible. On
Show overview ruler
This option determines if the right overview ruler to show annotations is visible or not.
On
Show line numbers This option switches the visibility of the left line number ruler.
Off
Highlight matching brackets
If this option is turned on, matching parenthesis '(' and ')' will be highlighted if the cursor is moved over them.
On
Highlight current line
If this is turned on, the current line in the editor will be highlighted with a specific color.
On
Show print margin This option switches the visibility of the print margin.
Off
Appearance colors
This list contains the color values of the
  • Line number foreground
  • Matching parens highlight
  • Current line highlight
  • Print margin
  • Linked position
Change their value by selecting  it with the right color button that opens color chooser dialog.

Number of Undo-Levels
Here you can adjust the number of undo levels of the editor.
25

Syntax
Foreground colors and style
This list contains the foreground colors values for
  • Keywords
  • Identifiers
  • String Values
  • Numeric Values
  • Comments
  • Operators and Braces
Change their value by selecting  it with the right color button that opens color chooser dialog.
The bold font style can be switched on by selecting the check box.


Annotations
Suppress error marker generation on save
Turning this option on will hinder the SQL editor to perform a syntax analysis on file save and associate error  markers with the file.
Off
Analyze annotations while typing
If this is turned on, the editor analyzes the typed text and adds problem  annotations if syntax errors were found.
On
Delay after last text change
After a key was typed the editor will wait this certain amount of milliseconds before it starts  analyzation.
500
Annotation presentation
In this list you can choose which types of annotations should be displayed by the editor using the specified foreground color.


Code Assist
Insert single proposals automatically
If  turned on, the SQL editor inserts single proposals automatically without prompting to choose from the list.
Off
Enable auto activation
If turned on, the content assist will be automatically enabled if a '.' is typed.
On
Adaptively quote identifiers
If this option is turned on, DbEdit will automatically quote identifiers that are lowercase or mixcased for those connections that store identifiers in uppercase or identifiers  that are uppercase for connections that store them in lowercase respectively.
On
Always quote identifiers
If this is turned on, identifiers will always be quoted. Else the Shift key has to pressed to force quoting. Off

Formatter













Templates

On this tab page you can add, edit or remove templates. When selecting Add or Edit, a dialog opens within that you can input the template text.
Currently there is only one template variable supported (position, int value) that you can use to specify positions the cursor will be set to when the template is applied to the text.








Legal Notice