21. Editors available in ADS (Revision #14)

Editors

Aqua Data Studio provides editors for specific files. Providing a Text Editor, SQL Editor, HTML Editor and XML Editor. Double clicking on a file within the Schema/Script Browser opens it in its associated editor within a new tab.

The editors consist of 4 types. Including:

Text Editor: Editor for editing text files.

SQL Editor: Editor for editing SQL files.

HTML Editor: Editor for editing HTML files.

XML Editor: Editor for editing XML files.

Editors - SQL Editor

The SQL editor allows users to easily edit SQL files with syntax coloring, and allows the user to execute and test the SQL Statements.

Abbreviations - Abbreviation support, within File->Options->Editors->SQL Editor->Abbreviations , allows for user-defined autocompletion. Lengthy blocks of SQL can be autocompleted with a few keystrokes.

As an example, the SQL command:

SELECT *

can be an abbreviation which autocompletes or expands to

SELECT * FROM Customers WHERE Freight > 500 and ShipCountry

Editing Options - Within File->Options->Editors->SQL Editor , the Caret and Caret Color of Overwrite and Insert mode are configurable, as are the Editor Background and Editor Foreground.

In-Line Diff Indicators - If the SQL document being edited is part of a source control repository, in-line diff indicators highlight adjacent to the row numbers, marking differences between the current edit and the current working copy from a repository. Right clicking in-line difference indcators allows performing a compare of the current edit to the currernt working copy from the the repository. Difference indicators also appear in the navigation bar on the right side of the editor. Clicking a difference indicator in the annotation bar scrolls the document to that location.

End of Line Type - Within File->Options->Editors->SQL Editor there is an option to force a specific EOL [End of Line] type.

Incremental Search - The Find dialog has several options: Match Case, Whole Words, Regular Expressions, Highlight Results, Wrap Around, Search Selection, Search Backwards and Incremental Search. All instances of the search terms can highlight within the SQL. If the Find button is clicked again, it selects the next instance of this term leaving the others still highlighted.

Bookmarks - Bookmarks serve as quick navigation tools. Toggling a bookmark with Ctrl+Shift+M creates a bookmark. Moving from bookmark to bookmark is done with the keystrokes Ctrl+Shif+Up (previous bookmark) or Ctrl+Shift+Down (next bookmark). Bookmarks appear in the annotation bar on the right side of the editor. Clicking a bookmark scrolls the document to that location.

New File Editors

New Editors: Now includes two new editors for JavaScript and Java. The editors come with all of the editing features available in Aqua Data Studio's other editors, like syntax highlighting, options for setting, abbreviations and more.


Java Editor	JavaScript Editor	Editor Options

File Editor Enhancements

Editor Bookmarks: Ability to set bookmarks in editor and then navigate through them quickly through hot keys or using the annotation bar which has indicators identifying the relative locations of the bookmarks within the editor content.

Abbreviations - Abbreviation support, within File->Options->Editors->Java Editor->Abbreviations and File->Options->Editors->JavaScript Editor->Abbreviations, allows for user-defined autocompletion. Lengthy blocks of code can be autocompleted with a few keystrokes.

As an example, the text:

can be an abbreviation which autocompletes or expands to:

import java.io.lang

Editing Options - Within File->Options->Editors->Java Editor and File->Options->Editors->JavaScript Editor, the Caret and Caret Color of Overwrite and Insert mode are configurable, as are the Editor Background and Editor Foreground.

In-Line Diff Indicators - If the java code being edited is part of a source control repository, in-line diff indicators highlight adjacent to the row numbers, marking differences between the current edit and the current working copy from a repository. Right clicking in-line difference indcators allows performing a compare of the current edit to the currernt working copy from the the repository.

End of Line Type - Within File->Options->Editors->Java Editor and File->Options->Editors->JavaScript Editor there is an option to force a specific EOL [End of Line] type.

Incremental Search - The Find dialog has several options: Match Case, Whole Words, Regular Expressions, Highlight Results, Wrap Around, Search Selection, Search Backwards and Incremental Search. All instances of the search terms can highlight within the text. If the Find button is clicked again, it selects the next instance of this term leaving the others still highlighted.

Editors - HTML Editor

The new HTML editor allows users to easily edit HTML files with syntax coloring for easier editing of files.

Abbreviations - Abbreviation support, within File->Options->Editors->HTML Editor->Abbreviations , allows for user-defined autocompletion. Lengthy blocks of HTML can be autocompleted with a few keystrokes.

Editing Options - Within File->Options->Editors->HTML Editor , the Caret and Caret Color of Overwrite and Insert mode are configurable, as are the Editor Background and Editor Foreground.

In-Line Diff Indicators - If the HTML document being edited is part of a source control repository, in-line diff indicators highlight adjacent to the row numbers, marking differences between the current edit and the current working copy from a repository. Right clicking in-line difference indcators allows performing a compare of the current edit to the currernt working copy from the the repository. Difference indicators also appear in the annotation bar on the right side of the editor. Clicking a difference indicator in the annotation bar scrolls the document to that location.

End of Line Type - Within File->Options->Editors->HTML Editor there is an option to force a specific EOL [End of Line] type.

Incremental Search - The Find dialog has several options: Match Case, Whole Words, Regular Expressions, Highlight Results, Wrap Around, Search Selection, Search Backwards and Incremental Search. All instances of the search terms can highlight within the HTML. If the Find button is clicked again, it selects the next instance of this term leaving the others still highlighted.

Editors - XML Editor

The new XML editor allows users to edit XML files within the Aqua Data Studio development environment using the powerful Aqua Data Studio editor including syntax coloring.

Abbreviations - Abbreviation support, within File->Options->Editors->XML Editor->Abbreviations , allows for user-defined autocompletion. Lengthy blocks of XML can be autocompleted with a few keystrokes.

Editing Options - Within File->Options->Editors->XML Editor , the Caret and Caret Color of Overwrite and Insert mode are configurable, as are the Editor Background and Editor Foreground.

End of Line Type - Within File->Options->Editors->XML Editor there is an option to force a specific EOL [End of Line] type.

Incremental Search - The Find dialog has several options: Match Case, Whole Words, Regular Expressions, Highlight Results, Wrap Around, Search Selection, Search Backwards and Incremental Search. All instances of the search terms can highlight within the XML. If the Find button is clicked again, it selects the next instance of this term leaving the others still highlighted.