Other new features ...  (Revision #11)

This page is reserved for any Last-minute features added after 4/1/2011

File Browser

Double Clicking or Openning a file, will open the file in an Aqua Data Studio associated editor or viewer.  If there is no associated component, then Aqua Data Studio will request the Operating System to 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.

HotKeys

Application now has HotKeys of CTRL-[NUMBER] on Windows and ALT-[NUMBER] on OSX/Linux to quickly move from Tab to Tab as some browsers have.

ER Modeler

Generate Script : Now has a statement separator option for "@" just like Schema Script Generator.

Schema Browser

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

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 retreive when openning the Table Data Editor from the schema browser on a table, and whether to prompt the user on changing the default every time the editor is open.

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.

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.

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.

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.

Schema Compare Results

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

Text Results Options

Added option File->Options->Results->Text Results->[Display only sum of rows effected per execution]. (To solve issue with Sybase ASE) AFScriptContext : 1429

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.