17. Editors & Viewers (Revision #1)

Editors

Aqua Data Studio provides editors for specific files. Providing a Text , SQL, HTML, XML, JavaScript, AquaScript and Java Editors. Double clicking on a file within the Schema/Files Browser opens it in its associated editor within a new tab. Dragging one or more files from the desktop into Aqua Data Data Studio will open each in a tab.

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.

Editors - Java, JavaScript and AquaScript

The Java, JavaScript and AquaScript 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	AquaScript Editor	Editor Options

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/AquaScript 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/AquaScript 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/AquaScript 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.

AquaScript Editor Autocompletion - These options set whether autocompletion is enabled for the AquaScript editor.

AquaScript Editor Autocompletion Enabled - Determines whether AquaScript Auto-completion is enabled.

AquaScript Editor Autocompletion Auto Popup - Code completion window automatically appears when appropriate.

AquaScript Editor Autocompletion Auto Popup Delay - How long to wait (in milliseconds) before automatically popping up the completion window.

AquaScript Editor Autocompletion Instant Substitution - Code completion performs instant substitution, if the search result contains only one item.

AquaScript Editor Autocompletion Pane Maximum Size - The maximum size of the completion pane window.

AquaScript Editor Autocompletion Pane Minimum Size - The minimum size of the completion pane window.

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.

Editors - Text Editor

The new text editor provides users with the ability to quickly edit SQL files without opening a query window or regular text files without leaving the Aqua Data Studio development enironment.

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

As an example, the text:

service

can be an abbreviation which autocompletes or expands to:

service for the next upgrade is included within a yearly subscription.

Editing Options - Within File->Options->Editors->Text 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 text 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->Text 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 - Regular Expressions

The full regular expression syntax accepted by RE is described here:



  Characters

    unicodeChar   Matches any identical unicode character
    \                    Used to quote a meta-character (like '*')
    \\                   Matches a single '\' character
    \0nnn                Matches a given octal character
    \xhh                 Matches a given 8-bit hexadecimal character
    \\uhhhh              Matches a given 16-bit hexadecimal character
    \t                   Matches an ASCII tab character
    \n                   Matches an ASCII newline character
    \r                   Matches an ASCII return character
    \f                   Matches an ASCII form feed character


  Character Classes

    [abc]                Simple character class
    [a-zA-Z]             Character class with ranges
    [^abc]               Negated character class
        
 NOTE: Incomplete ranges will be interpreted as "starts from zero" or "ends with last character".
 I.e. [-a] is the same as [\\u0000-a], and [a-] is the same as [a-\\uFFFF], [-] means "all characters".

  Standard POSIX Character Classes

    [:alnum:]            Alphanumeric characters.
    [:alpha:]            Alphabetic characters.
    [:blank:]            Space and tab characters.
    [:cntrl:]            Control characters.
    [:digit:]            Numeric characters.
    [:graph:]            Characters that are printable and are also visible.
                         (A space is printable, but not visible, while an
                         `a' is both.)
    [:lower:]            Lower-case alphabetic characters.
    [:print:]            Printable characters (characters that are not
                         control characters.)
    [:punct:]            Punctuation characters (characters that are not letter,
                         digits, control characters, or space characters).
    [:space:]            Space characters (such as space, tab, and formfeed,
                         to name a few).
    [:upper:]            Upper-case alphabetic characters.
    [:xdigit:]           Characters that are hexadecimal digits.


  Non-standard POSIX-style Character Classes

    [:javastart:]        Start of a Java identifier
    [:javapart:]         Part of a Java identifier


  Predefined Classes

    .         Matches any character other than newline
    \w        Matches a "word" character (alphanumeric plus "_")
    \W        Matches a non-word character
    \s        Matches a whitespace character
    \S        Matches a non-whitespace character
    \d        Matches a digit character
    \D        Matches a non-digit character


  Boundary Matchers

    ^         Matches only at the beginning of a line
    $         Matches only at the end of a line
    \b        Matches only at a word boundary
    \B        Matches only at a non-word boundary


  Greedy Closures

    A*        Matches A 0 or more times (greedy)
    A+        Matches A 1 or more times (greedy)
    A?        Matches A 1 or 0 times (greedy)
    A{n}      Matches A exactly n times (greedy)
    A{n,}     Matches A at least n times (greedy)
    A{n,m}    Matches A at least n but not more than m times (greedy)


  Reluctant Closures

    A*?       Matches A 0 or more times (reluctant)
    A+?       Matches A 1 or more times (reluctant)
    A??       Matches A 0 or 1 times (reluctant)


  Logical Operators

    AB        Matches A followed by B
    A|B       Matches either A or B
    (A)       Used for subexpression grouping
   (?:A)      Used for subexpression clustering (just like grouping but
              no backrefs)


  Backreferences
       There are two different backreferences for regular expression and replacement string.
       In a regular expression:
    \1    Backreference to 1^st  parenthesized subexpression
    \2    Backreference to 2^nd parenthesized parenthesized subexpression
    \3    Backreference to 3^rd parenthesized subexpression
    \4    Backreference to 4^th  parenthesized subexpression
    \5    Backreference to 5^th  parenthesized subexpression
    \6    Backreference to 6^th  parenthesized subexpression
    \7    Backreference to 7^th  parenthesized subexpression
    \8    Backreference to 8^th  parenthesized subexpression
    \9    Backreference to 9^th  parenthesized subexpression

       In a replacement string:
    $1   Backreference to 1^st parenthesized group from the search string
    $2   Backreference to 2^nd parenthesized group from the search string
    $3   Backreference to 3^rd parenthesized group from the search string
    $4   Backreference to 4^th parenthesized group from the search string 
    $5   Backreference to 5^th parenthesized group from the search string
    $6   Backreference to 6^th parenthesized group from the search string
    $7   Backreference to 7^th parenthesized group from the search string
    $8   Backreference to 8^th parenthesized group from the search string
    $9   Backreference to 9^th parenthesized group from the search string

 
All closure operators (+, *, ?, {m,n}) are greedy by default, meaning that they match as 
many elements of the string as possible without causing the overall match to fail. If you 
want a closure to be reluctant (non-greedy), you can simply follow it with a '?'. A 
reluctant closure will match as few elements of the string as possible when finding 
matches. {m,n} closures don't currently support reluctancy.

Line terminators
A line terminator is a one- or two-character sequence that marks the end of a line of the 
input character sequence. The following are recognized as line terminators:

A newline (line feed) character ('\n'),
A carriage-return character followed immediately by a newline character ("\r\n"),
A standalone carriage-return character ('\r'),
A next-line character ('?'),
A line-separator character ('?'), or
A paragraph-separator character ('?).

Image Viewer

The image viewer allows a user to view a list of images in a preview pane and operate on any selected image.

The image viewer may be invoked from the Grid Results of the Query Window, or viewed from within the Table Data Editor while the "Convert Binary to hex" option is unchecked in File->Options->Results->Data Retrieval. A user may query a database for binary/image data and then load it into the image viewer. The image viewer supports GIF, JPG and PNG file formats.