Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

With the caret in any place in a statement where you can type something other than a table name or a column name, and at least one character just before the caret, activating auto completion displays a list of keywords that starts with the letters you have typed so far. As you continue to type, the list narrows.

Image RemovedImage Added

The list of keywords is database specific, selected based on the database type for the connection currently selected in the Database Connection list above the editor.

With the caret placed where a table or view name may be typed in a supported SQL statement type, the auto completion list shows a list of tables and views from the currently selected database connection, assuming you are actually connected to the database. The following figure shows the completion pop up with table names that contain the letter S. 

Image RemovedImage Added

A completion pop-up showing column names is shown when the caret is placed where a column name may be typed. 

Image RemovedImage Added

DbVisualizer provides auto completion for table and columns names for the following DML commands:

...

Auto completion for DbVisualizer commands is very similar. Activating it after a partial command name lists all matching commands. If you activate it after a complete command name, you get a list of all valid parameters for the command. After a parameter name, you can select from a list of valid values.

Image RemovedImage Added

For the @export set command, the parameter list is adapted for the specified output format after you have entered the Format parameter setting, for instance only showing parameters that are valid for the CSV format.

Image RemovedImage Added

To display the completion pop-up, use the key binding Ctrl-SPACE (by default). You select an entry in the pop-up menu with a mouse double-click, the ENTER key, or the TAB key. To cancel the pop-up, press the ESC key.

...

Here's an unfolded script with the column expression selected:

Image RemovedImage Added

And here is the same script with the selection folded:

Image RemovedImage Added

You can fold more than one part of a script using the same procedure.

To unfold just one part, select the folding marker (be careful to select all of it) and then choose Toggle Fold Selection from the menu again. To unfold all folded parts, use Expand All Foldings.

...

To do this in the SQL editor, click the mouse where you want to start the selection and then press the Alt key (by default) while you extend the selection by dragging the mouse. If you prefer to use  the Ctrl key as the modifier, you can change the default in Tool Properties in the SQL Commander category under the General tab.

Image RemovedImage Added

Highlighting Matches

Index term
secondaryedit
tertiaryhighlight matches
primaryscript
Instead of searching for occurrences of a text string and navigating to each occurrence, it is sometimes useful to get all occurrences highlighted. To do this, select a text string that is at least three characters long and contains at least one letter or digit (you can change the colors used in Tool Properties  dialog, in the General / Appearance / Editor Styles category).

Image RemovedImage Added

Tab Key Treatment

...