Like 0

Editors & Viewers

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. Existing abbreviations can be cloned to make variations.

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.

Block Selection - Clicking the Block Selection button in the Editor Toolbar lets you drag a selection rectangle around a single character or multiple columns of characters anywhere in the editor. You can copy the block selection, create a new block and paste the contents.

Line Wrap - Clicking the Line Wrap button lets you wrap lines in the editor so that a file's contents wrap within the visible area of the editor pane. A Line Wrap symbol appears where the editor wraps the lines.

Row Selection - Dragging down the far left side of the editor (where line numbers appear if they are enabled) allows selecting the full lines of text you drag across without having to send your cursor to the end of each line.

Control Click Selection - if CTRL is held down when clicking on a word, the entire word gets selected so that copying it or cutting can be done quickly.

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. Existing abbreviations can be cloned to make variations.

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.

Block Selection (not available in the AquaScript Editor) - Clicking the Block Selection button in the Editor Toolbar lets you drag a selection rectangle around a single character or multiple columns of characters anywhere in the editor. You can copy the block selection, create a new block and paste the contents.

Control Click Selection - if CTRL is held down when clicking on a word, the entire word gets selected so that copying it or cutting can be done quickly.

Editors - HTML Editor

The 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. Existing abbreviations can be cloned to make variations.

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.

Control Click Selection - if CTRL is held down when clicking on a word, the entire word gets selected so that copying it or cutting can be done quickly.

Breadcrumb Trail (HTML Editor only) - The top of the HTML editor displays a toolbar indicating the nested HTML elements that contain your caret as you type. To quickly move your caret up the nested elements, click on them in the Breadcrumb Trail.

Editors - XML Editor

The XML editor allows users to edit XML files within the Aqua Data Studio development environment using the powerful Aqua Data Studio editor which includes 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. Existing abbreviations can be cloned to make variations.

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.

Control Click Selection - if CTRL is held down when clicking on a word, the entire word gets selected so that copying it or cutting can be done quickly.

Editors - Text Editor

The 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. Existing abbreviations can be cloned to make variations.

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.

Control Click Selection - if CTRL is held down when clicking on a word, the entire word gets selected so that copying it or cutting can be done quickly.

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 1st  parenthesized subexpression
\2    Backreference to 2nd parenthesized parenthesized subexpression
\3    Backreference to 3rd parenthesized subexpression
\4    Backreference to 4th  parenthesized subexpression
\5    Backreference to 5th  parenthesized subexpression
\6    Backreference to 6th  parenthesized subexpression
\7    Backreference to 7th  parenthesized subexpression
\8    Backreference to 8th  parenthesized subexpression
\9    Backreference to 9th  parenthesized subexpression

       In a replacement string:
$1   Backreference to 1st parenthesized group from the search string
$2   Backreference to 2nd parenthesized group from the search string
$3   Backreference to 3rd parenthesized group from the search string
$4   Backreference to 4th parenthesized group from the search string 
$5   Backreference to 5th parenthesized group from the search string
$6   Backreference to 6th parenthesized group from the search string
$7   Backreference to 7th parenthesized group from the search string
$8   Backreference to 8th parenthesized group from the search string
$9   Backreference to 9th 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.