The new Visual Editing for Security allows a user to visually CREATE, ALTER and DROP security objects with easy to use forms. The security objects supported for all databases include Users, Roles, Profiles, Logins, Server Roles and Object/Column Permission. The visual editors also provides an SQL preview of all the commands to be executed to commit the operation.

Below is a list of databases and the security objects supported by this query tool:

• DB2: Users, Roles, Object Permissions, Column Permissions
• Informix: Users, Roles, Object Permissions, Column Permissions
• MySQL: Users, Object Permissions, Column Permissions
• Oracle: Users, Roles, Profiles, Object Permissions, Column Permissions
• Sybase Anywhere: Users, Roles, Object Permissions, Column Permissions
• Sybase: Logins, Server Roles, Users, Roles, Object Permissions, Column Permissions
• MS SQL Server: Logins, Server Roles, Users, Roles, Object Permissions, Column Permissions
• Postgresql 7.4/8.0: Users, Roles, Object Permissions [Column Permissions not supported by Postgresql]
• Postgresql 7.2/7.3: Not Supported
  

The Query Analyzer window now has a 2 modes: The default SplitPane mode and the new MultiTab results mode. The SplitPane view has the SQL editor and the results in one view separated by a splitpane. The MultiTab results mode has one full view for the SQL Editor and separate tabs for the results (see screenshots). The default mode is the SplitPane. The default mode of Query windows may be set under File->Options->[General]:[Query Windows: MultiTab Query Window]. You may also change the mode of any open window using the menu Window->MultiTab/SplitPane Results (CTRL-F7). You may also cycle through the results of the MultiTab results with the hotkey of CTRL-1.

The Query Analyzer is now highly customizable, including options for both the editor and the results. Below is a list of customizable options for the editor and the results.

Editor: File->Options->[Editor]

Query analyzer scripts now have support for 4 new client side commands which allow you to execute a stored procedure with local variables binded to the parameters. This allows for the execution of procedures with OUT parameters. The commands include print, println, variable and executecallableQuery. Client side commands are identified by a dot at the beginning of the command line, and multiple commands can be executed within one batch statement. The schema browser now contains object scripting for procedures and functions that include "EXECUTE" and "EXECUTE BIND". The script EXECUTE will generate the appropriate code needed to execute the object according to the database procedural language (ie. PL/SQL, T-SQL). The EXECUTE BIND will generate the appropriate Aqua Data Studio client side commands to execute the object. To easily generate the needed client commands to execute a procedure or function, you may browse in the schema browser to locate the procedure or function and right-click on the object to select "EXECUTE BIND" from the Script Object menus.

Aqua Data Studio now provides an Export Tool which allows you to export the contents of any table or the results of any SELECT statement. Exported data may be saved in a delimited text file or a file with INSERT statements. Aqua Data Studio now also has a context sensitive "Tools" menu in the schema browser popup menu, so a user may browse through the schema to the Table to be exported and then run the Tool. The Tool will use the currently selected Server Connection and the currently select database/schema/table.

Application
--------------------
1. Option Dialog: Changed the Tabbed View to an Outlook Tabbed View (aka Firefox/Intellij Option Dialog Look)
2. Dialog Windows: Converted border of Titled Borders from single black line to Etched Borders for a better look.
3. Message & Confirmation Dialogs: Now have Mnemonics enabled for hot key actions.
4. Application & Query Toolbars are now 16x16 size.
5. Application: When closing the application the Dialog prompt to Save files will also have "Discard All".
6. Closing Query Windows: Added option in File->Options->[General] to allow the ability to specify if ADS prompts a user to save a modified query window that doesn't have a file associated with it.
7. Window Menu: Added option to Hide/Show application toolbar (CTRL-F8)
8. Schema Popup Menu: Now has Tools->Import/Export menu item for context sensitive import/export functionality.
9. Look and Feel: Added optional command line parameter called ads.forcelaf which allows users to set their own look and feel with command line option of "-Dads.forcelaf="
11. Window Menu: Added option to enable the toggling of the current Query Analyzers MultiTab/SplitPane mode. (CTRL-F7)
12. CTRL-1 HotKey: Cycles through Query Window Results in MultiTab query window
13. CTRL-ALT-(RIGHT/LEFT ARROW) Focus back and forth between the Tree View and the Query Tab View
14. Register Properties Dialog: Now has an advanced tab.
- Advanced tab has driver properties for all database types where a user may specify driver parameters
- Advanced tab has Characterset combo box for Sybase.
15. Register Properties Dialog for Sybase Anywhere now has Database field so user may specify the database to connect to.
16. MS SQL Server 7.0 & 2000/5 - Added Windows Authentication
- Added Option: "Windows Single Sign-On" option to allow a user to login using Windows Authentication with the currently logged in username/password of the Windows OS. (Only supported on Windows OS)
- Added Option: "Windows Authentication" option to login using Windows Authentication with the specified username/password. (Only Windows Authentication Option supported on non-Windows platforms (Linux, OSX, etc)

Query Analyzer
--------------------
1. Added Window Menu with options to Hide/Unhide the Query Toolbar and Query Results.
2. Editor Popup menu: Added CTRL-SHIFT-DELETE short-cut for Clear Document.
3. Editor and Text/History/Message Results: Added "Clear Document" option in the popup menu to clear all document text.
4. Editor: Added Windows shortcut keys for Cut: Shift+Del / Copy: Ctrl+Ins / Paste: Shift+Ins
5. Query Analyzer: Openning a Query Analyzer window will automatically set the current database according to the database selected in the schema browser
6. Popup menu on Query Analyzer tab now includes "Close All" and "Close Others"
7. SQL Server Query Analyzer: When openning a new query window, the connection will be set by default to the default database assigned to the user. This will only be overridden if the user currently has selected a different database in the schema browser.
8. Editor: Auto-Comment: If a text selection is made, the CTRL-/ will do a block comment around the selected text, instead of a line comment
9. To Upper/To Lower: If no selection is made then the command will apply toUpper/toLower to the current word based on the caret position.
10. Morph to Upper/Lower: The toUpper/toLower now do not change single or double quoted text
11. Introduce Value Stubs: For MS SQL Server and UniqueIdentifier datatypes, the value stub is now NEW() instead of ''.
12. Popup menu, added "Copy w/ Headers", "Copy w/ RowCount" and "Copy w/ Headers & RowCount" to allow the coping of the selected text with the headers and a row count column

SQL History
--------------------
1. Selecting text into Query Window now selects all of the selected statements and not just the current statement
2. Added "Save Script" toolbar button which saves all currently selected statements into a file.

Schema Browser
--------------------
1. Oracle: To Package and Package Body nodes, added functions and procedures to allow the browsing within the package and to script EXECUTE and EXECUTE BIND 2. Folders and Files are now sorted
3. Added to popup menu "Refresh" - F5 to allow a user to refresh the node without collapsing/expanding the node
4. Added to popup menu "Script Object -> SELECT (*)" to Tables to generate a SELECT statement with '*' as the fields instead of the column names listed.
5. Drag-n-Drop: User may now move or copy (CTRL-Down) a server registration from folder to folder by dragging and dropping a server registration node.
6. Drag-n-Drop: User may now drag-n-drop a Table/View or Column from the schema browser to the Query Window. (ALT-Down will add item with a ", " prepended)
7. Browsing the Schema & Script browser with the keyboard will automatically scroll the pane to the selected entry.
8. Auto-Reconnect: Implemented Auto-Reconnect for Schema Browser, Visual Editing and SQL Scripting. (Postgresql requires latest JDBC driver, and Informix is not supported by Driver)
9. DB2/Sybase/MS SQL Server Schema Browser - Dependancies Node: Converted the Dependant Object Node to the actual object node so the objects have context sensitive menus and object icons

Table Data Editor
--------------------
1. Added refresh button to only refresh the data, but not save. [In case the Max Results is changed]
2. Inserting Date/Time and setting NULL now affects all selected cells, not just the current.
3. Added File Menu with Hot-Keys

Visual Editing
--------------------
1. Oracle Visual Editors for View, Trigger, Procedure, Function, Package and Package Body: Added "Show Errors" button to display errors for source of invalid object
2. Postgresql 8.0 - Tablespaces: Added support for tablespaces: Schema Browser, Visual Editing and Scripting DDL
3. Postgresql 8.0 - Visual Edit User/Role: Added permission options for tablespaces
4. Visual Table Editor for Sybase: Added ability to drop columns
5. Scripting Columns for Sybase: Added ALTER and DROP columns

Import/Export Tool
--------------------
1. Added "yyyyMMdd" and "yyyyMMddHHmmssZ" date/datetime formats
2. Scripting INSERT statements now has an optional statement separator for the script.
3. Scripting INSERT statements now use the configured scripting options for identifiers and statement separator

Application
--------------------
1. Main application title still contained last file openned even after last query window was closed.
2. Mac OSX Look and Feel - Background of application was beening set to light gray.
3. MS SQL Server Registration: Host name for instances now supports "hostname\instance" in addition to "\\hostname\instance"

Query Analyzer
--------------------
1. SQL Server: Introduce Value Stubs: Months in the date were zero based. Changed to one based.
2. Grid Format of NULLs: NULL value formatting was not being displayed in Grid Results.
3. Query Analyzer: Alt-D hot key only worked for the last query window openned
4. Query Analyzer in MultiTab results: Fixed focus of components as CTRL-TAB cycles through query windows.
5. Auto-Complete: Bug which caused auto-completion to only show "Please Wait ..." and nothing else, now fixed.
6. Default for Instant Substitution in Auto Completion is now false
7. Auto Completion: Tab key now closes completion window after completing if there is only one item in the window.
8. Syntax Coloring for Postgresql: Multi-line/Single quoted text is colored as if it was not single quoted for support of CREATE Procedure syntax coloring
9. Generic JDBC/ODBC Connections: .setMaxRow() is not supported by some JDBC/ODBC drivers (SQLite) which caused ADS to fail on queries.
10. Query Analyzer: Quering and displaying large BLOBs would lockup ADS.
11. Informix Syntax Coloring: Added RESOURCES, STATISTICS, HIGH, MEDIUM, SUBSTR
12. Editor: Find & Replace would replace multiple times according to how many times it had been used, which cause problems if the find string was a substring of the replace string.
13. MS SQL Server Query Results: values of tinyint columns where being displayed incorrectly.
14. Execute Explain (CTRL-Shift-Enter): was treating all comments as client side comments which removed Oracle Hints before execution.
15. Postgresql: Added support for Implicit Case-Sensitive schema objects
16. SQL Server: Show Explain Plan: When Show Explain Plan was enabled and a multi-result select query was executed, not all resultsets were displayed
17. Sybase: Executing Procedure which returns row counts and an error message produces a "getUpdateCount" error message instead of the actuall error message.
18. MySQL Results for tinyint(1) would return as [Err].

Schema Extraction
--------------------
1. Sybase Index Extraction: On HP/Unix: Unique and Clustered flags not retreived. The ANDing of Hex values doesn't work on Sybase HP/UNIX. Converted queries to use ANDing decimal values.
2. MS SQL Server & Sybase Anywhere: Extraction of Procedure/Function. Trimming spaces from procedure lines could cause problems if line doesn't end with line feed
3. Script Index CREATE: Multi-column Index would omit columns after the first one.
4. Sybase Indexes: Extracting and Viewing didn't work for non-capitalized Indexes.
5. Oracle Scripting Constraints: Added constraint state to the DDL which was being omitted for primary key, unique and check constraints.
6. Oracle Scripting Foreign Keys: Added constraint state to the DDL which was being omitted.
7. Script Table CREATE for Postgresql - Numeric & Decimal types now support Precision and Scale.

Table Data Editor
--------------------
1. Table Data Editor & History Toolbars: Changed Toolbar button/icon to 16x16 instead of 20x20
2. Table Editor for Postgresql - Numeric & Decimal types now support Precision and Scale.
3. SQL Server: Table Editor: Generated date formats with "YMD", which didn't work in all locales. Format is now set with SET DATEFORMAT
4. Execute Edit: Didn't work when query contains character "ß" (eg Straße (street)). This character becomes "SS" when converted to uppercase.
5. SQL Server: Table Data Editor: UNIQUEIDENTIFIER columns are now editable.

Schema Browser
--------------------
1. DB2 Function/Procedure Scripting: Added support for external functions/procedures
2. Schema Browser Drag-n-Drop: Added ability to drag-n-drop Procedures, Functions and Parameters to Query Window.
3. MySQL Schema Browser: 4.1/5.0 - Process Info List didn't show the list of processes.
4. SQL Server 2005 Schema Browser/Constraint Extraction: Didn't list or extract check constraint.
5. Sybase Anywhere 9 Schema Browser/Constraint Extration: Didn't list or extract check constraint.
6. Schema Browser: Oracle Packages, Package Bodies and Java Sources. Queries are now based on ALL_OBJECTS.
7. Schema Tree: Move (Drag/Drop): You may now move servers to the root 'Database Server' node.
8. Oracle Schema Browser Table Node: Filtered Tables that start with BIN$ for Oracle 10g which are the tables in the Recycle Bin
9. Oracle Schema Browser: Added the "PUBLIC" schema folder in the schemas.
10. DB2 Schema Browser - Dependancies Node: Added query to include Procedures that are dependant on the table
11. SQL Server schema browser, column node: Was displaying length of NCHAR and NVARCHAR twice the size.
12. Informix Queries on System Catalogs now explicitly query on the informix schema (eg informix.systables)
13. Schema Browser for Oracle/Sybase Anywhere - Sorting Procedure and Function folder.
14. SQL Server Case Sensitivity: Stored Procedure & Function schema extraction and visual editing didn't work on SQL Servers with case sensitivity
15. Generic Schema Browser: Schema Filter wasn't working.
16. Informix Synonyms mapped to objects in different database: Added support in displaying them in the schema browser, scripting the SQL and added to auto-completion.
17. Scripts Browser: Showed all files. Now only shows files with extensions defined in File->Options->General
18. MySQL 4.1 Schema Browser for Table didn't show columns and indexes.
19. MS SQL Server Schema Browser & Query Analyzer db combo box: Now only lists the databases which the user has access to.

Import/Export Tool
--------------------
1. Import Tool: Informix 7.3 doesn't support quoted qualified columns
2. Import Tool: Importing files with spaces between comma separated columns (eg: column1, column2) would add a space to the beginning of column string data.
3. Import/Export and Save Results Dialog: Added [Default] item for encoding types.
4. Oracle Export Tool: Timestamp columns with precision would cause export to not work.
5. CLOB data type: Multi-Line CLOB values were converted to single line values in Text Display and Import/Export Tool.
6. MySQL & Postgresql: Import/Export Tool and Table Data Editor now escapes backslash to a double backslash when generating string values in INSERT statements
7. Unclosed single and double quotes in server side comments caused parser to disregard statement separators. fixed. (was fixed in 3.5.13, reintroduced in 3.7.1)
8. Displaying of Query Stats: Added "Command was executed successfully" into the query stats to be enabled/disabled, which is displayed when a statement is executed and zero records where modified
9. Query Stats: Added hot key to enable/disable ALT-SHIFT-R;

Visual Editing
--------------------
1. Postgresql: Drop Function sometimes didn't work, depending on whether the parameters were extracted in the correct ordering.
2. Index View Properties: Was displaying the datatype of the column incorrectly.
3. Sybase: Database Devices: Support for Visual Editing and Scripting of devices larger then 2G.
4. View/Alter Table for DB2: Identity value was displayed incorrectly for columns with a column check constraint.
5. After closing last query window, give focus to Schema/Script Browser.
6. Postgresql: Script Function or Visual Edit Function incorrectly generated parameter type definition for datatype varchar by placing a '()' after the varchar.
7. SQL Server/Sybase: Script Alter and Alter of Procedures/Functions which had comment blocks before the CREATE statement would not work.
8. Large Resultsets/Out of Memory: ADS now has error checking for running out of memory while quering for very large resultsets
9. Table Editor for Oracle OCI connections: Didn't set the correct database and schema which prevented the creation of a table