Features

SQL Code Editor PDF Print E-mail

QiD provides a powerful editor with many features to improve the process of creating, viewing and modifying the SQL and Script code that will be executed. The most obvious facility is the colour syntax highlighting that improves the readability of code and helps to catch syntax errors.

The QiD editor in action

The highlighting styles can be modified to suit your preferences. Each item type (comments, commands, keywords, identifiers, strings etc) can have its own font, font size, bold, italics, foreground colour, background colour, border, underline and strikeout settings.

The editor includes all of the expected tools to select, cut, copy and paste text. Further it provides the following:

  • Multi-level Undo / Redo. A separate undo/redo stack is kept for each document that you are working on.
  • Line modification marking to show lines that have been modified and saved (green) or modified but not yet saved (yellow)
  • Powerful Find / Replace capability including normal, wildcard and regular expression matching
Find and replace dialog
  • Block indent / undent, comment / uncomment
  • Bracket matching
  • Statement and region outlining. Statements and block comments are automatically given an outlining control that allows the text to be expanded or collapsed (see line 10 below). Additional regions can be defined using the – Region / -- End Region directives to allow greater control. The editor has toolbar controls to quickly expand or collapse all regions.
The QiD editor showing statement folding