Skip to content

Locating SQL Errors

When a statement fails, DbVisualizer marks the error in the editor, so that you can find and fix it. If the database reports the position of the error, the text at that position is underlined with a red wavy line. Otherwise, the whole statement is underlined. Point to the underline to see the error message.

Moving between errors

  • Each error also has a marker in the right margin of the editor. Click the marker to scroll to the error.
  • To move between the errors using the keyboard, assign keyboard shortcuts to Insertion Point to Next Marker and Insertion Point to Previous Marker, in the Editor Commands node of the Key Bindings category in Tools → Tool Properties. See Changing Keyboard Shortcuts.
  • In the Log tab, click the FAILED link of a statement to move the caret to the error. To find the failed statements, use Goto Next Failed and Goto Previous Failed in the right-click menu of the log.

Choosing which errors are marked

Two options in SQL Commander → SQL Commander Options decide what is marked:

  • Show Error Position Markers marks the position of the error, for databases that report it.
  • Show Error Statement Markers marks the whole failed statement, when the position isn't marked: either because the database doesn't report it, or because Show Error Position Markers is off.

To get fewer markers, turn off Show Error Statement Markers and keep Show Error Position Markers on. Then only the errors with a position reported by the driver are marked.

To set the defaults, use the General / SQL Commander category in Tools → Tool Properties.