Other new features ...  (Revision #51)

File Browser

Double Clicking or Opening a file will open the file in an Aqua Data Studio associated editor or viewer.  If there is no associated component Aqua Data Studio will request the Operating System open the file with the associated application.  For Example, double clicking an MS Excel file would request the Operating System to open the file, which would open it with MS Excel.

Deleting a file in the file browser will now try to move it to the Recycle Bin if possible; otherwise it will delete the file permanently.  The Recycle Bin is supported for the Windows and OSX 10.6+ platforms.

Schema Browser

Selecting multiple objects, then dragging and dropping to query window will drop all the object names separated with a comma.

Object Names Separated by Commas

Table Data Editor

Added options File->Options->Table Editor->Table Data Editor->[TOP default size] & [Prompt user for TOP size].  This allows the user to set the TOP number of rows to retrieve when opening the Table Data Editor from the schema browser on a table, and whether to prompt the user on changing the default every time

TOP Size Prompt

Query Completion Sound

Added option File->Options->General->Query Window->[Play Sound] which allows the user to choose an audio file to play once a query has completed execution.

Query Completion Sound

Editor Matching Braces Color

Added option File->Options->Editors->{Editor Type}->General->Matching Braces Background.  Allowing the user to change the color of the matching braces.

Matching Braces Background Highlight

Query Window

Added right mouse click popup menu action "Clone Window with Content" : Allowing a user to quickly clone the window with the same text content.

Clone Window with Content

 Support for remembering last parameterized varibale value per execution in the Query Window

Parameter variable

A new option in ADS 10.0 allows to remember the last entered parameterized variable in the Query Window. These values will be remembered per query window and will be discarded on the application exit. The default value will be overriden by the lat value entered by the user.

Save Results to Excel, View in Excel, View as Spreadsheet

Spreadsheet content will now fit columns to width with a max of 50 characters.

Query Window Grid Results

The quick filter now supports regular expressions.

Quickfilter Regular Expressions

Schema Compare Results

The right mouse click menu now has the option "View as Spreadsheet".

Schema Compare Results View as Spreadsheet

Text Results Options

Added option File->Options->Results->Text Results->[Display only sum of rows effected per execution].

Script Object to Window CREATE (FULL)

Oracle 10g, DDL extraction now supports/scripts external tables properly.  The base table DDL generates with the “ORGANIZATION EXTERNAL” information.

Key binding to "New Frame Window" - Ctrl-Alt-N

A new default key binding to "New Frame Window" is added in the latest version. With Ctrl-Alt-N a new frame window can be easily opened.

New Frame Window Keyboard Shortcut

Hide Application Tree Tabs - Servers, Files and Projects Tab

A new option to hide/show the 3 tabs - Servers, Files and Project is introduced

New option - Case for auto-completion

For users who follow the convention to have upper case SQL keywords and lower case fields and columns for readability, we have introduced Case for auto-completion. New feature can be enabled in File->Options->Scripts->[DB]->[Case for auto-completion] = {Default, Upper Case, Lower Case}

 New option in File Browser to quickly mount home and desktop folders

A new option in ADS 10.0 allows users to quickly mount the home and desktop folders in the File Browser. In the Filesystem tab, right mouse click menu now displays "Show/Hide Desktop" and "Show/Hide USer Home"

Show/Hide Desktop and User Home