3.7.24: FEATURE: 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.
FEATURE: Register Properties Dialog for Sybase Anywhere now has Database field so user may specify the database to connect to.
FIX: MySQL Results for tinyint(1) would return as [Err].
3.7.23: FEATURE: 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)
- Requires latest jTDS Driver 1.0 with ntlmauth.dll (http://www.aquafold.com/download/jdbc-drivers/jTDS/)
- copy jtds.jar to location (<ADS_INSTALL>\lib\jtds.jar)
- copy ntlmauth.dll to root ADS directory (<ADS_INSTALL>\ntlmauth.dll)
FIX: MySQL 4.1 Schema Browser for Table didn't show columns and indexes.
FIX: MS SQL Server Registration: Host name for instances now supports "hostname\instance" in addition to "\\hostname\instance"
FIX: MS SQL Server Schema Browser & Query Analyzer db combo box: Now only lists the databases which the user has access to.
3.7.22: FEATURE: Schema Browser for 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
TESTING: Tested database version support for Oracle 10g, DB2 8.2, Postgresql 8.0, Sybase Anywhere 9, MySQL 4.1 (5.0-Alpha), MS SQL Server 2005
FIX: Schema Browser Drag-n-Drop: Added ability to drag-n-drop Procedures, Functions and Parameters to Query Window.
FIX: MySQL Schema Browser: 4.1/5.0 - Process Info List didn't show the list of processes.
FIX: SQL Server 2005 Schema Browser/Constraint Extraction: Didn't list or extract check constraint.
FIX: Sybase Anywhere 9 Schema Browser/Constraint Extration: Didn't list or extract check constraint.
3.7.21:
FEATURE: Variable Binding: Query Scripts: Added 3 client side commands to support execution of stored procedures with variables binded to parameters.
- Added commands variable, print, println and executeCallableQuery. (Use Procedure->Script Object->EXECUTE BIND to generate example syntax)
- .println (.print) - Syntax: .println { variable_name | 'text value' }, ... n
- .variable - Syntax: .variable <variable_name> datatype [, value]
- .executeCallableQuery - Syntax: .executeCallableQuery 'parameter_name<datatype,{in | out | inout}>[, ...]', <LINE_BREAK>
{ CALL <PROCEDURE_NAME>( ? { , ? ... } ) }
{ ? = CALL <PROCEDURE_NAME>( ? { , ? ... } ) }
FEATURE: Schema Browser: Script Procedure: Added Script EXECUTE & EXECUTE BIND
FIX: SQL Server: Table Editor: Generated date formats with "YMD", which didn't work in all locales. Format is now set with SET DATEFORMAT
FIX: Execute Edit: Didn't work when query contains character "�" (eg Stra�e (street)). This character becomes "SS" when converted to uppercase.
FIX: Sybase Anywhere 9: Extract Constraints didn't work.
FIX: Postgresql: Drop Function sometimes didn't work, depending on whether the parameters were extracted in the correct ordering.
3.7.20: FEATURE: Oracle Visual Editors for View, Trigger, Procedure, Function, Package and Package Body: Added "Show Errors" button to display errors for source of invalid object
FIX: SQL Server: Show Explain Plan: When Show Explain Plan was enabled and a multi-result select query was executed, not all resultsets were displayed
FIX: Main application title still contained last file openned even after last query window was closed.
FIX: Scripts Browser: Showed all files. Now only shows files with extensions defined in File->Options->General
FIX: Sybase: Executing Procedure which returns row counts and an error message produces a "getUpdateCount" error message instead of the actuall error message.
FIX: SQL Server: Table Data Editor: UNIQUEIDENTIFIER columns are now editable.
FIX: DB2 Function/Procedure Scripting: Added support for external functions/procedures
FIX: SQL Server: Introduce Value Stubs: Months in the date were zero based. Changed to one based.
3.7.19: FEATURE: Dialog Windows: Converted border of Titled Borders from single black line to Etched Borders for a better look.
FEATURE: Message & Confirmation Dialogs: Now have Mnemonics enabled for hot key actions.
FEATURE: History: Selecting text into Query Window now selects all of the selected statements and not just the current statement
FEATURE: History: Added "Save Script" toolbar button which saves all currently selected statements into a file.
FEATURE: Application & Query Toolbars are now 16x16 size.
FEATURE: Text Results Options: Added "Always display records effected" as an option which will display "records effected" even if Display Query Stats are off.
FEATURE: Script Browser: Folders and Files are now sorted
FIX: Text Results: When 'Display Query Stats' are OFF the Record Count results prints extra line feed.
FIX: 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.
FIX: 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
FIX: Grid Format of NULLs: NULL value formatting was not being displayed in Grid Results.
FIX: Query Analyzer: Alt-D hot key only worked for the last query window openned
FIX: Query Analyzer: Multi-Panel View - CTRL-E didn't work while in a results tab
FIX: Grid Results: Sorting for numeric/date data types was broken in build 3.7.18
3.7.18: FEATURE: Editor: Added Windows shortcut keys for Cut: Shift+Del / Copy: Ctrl+Ins / Paste: Shift+Ins
FEATURE: Table Data Editor: Added refresh button to only refresh the data, but not save. [In case the Max Results is changed]
FEATURE: Table Data Editor: Inserting Date/Time and setting NULL now affects all selected cells, not just the current.
FEATURE: Import/Export Tool: Added "yyyyMMdd" and "yyyyMMddHHmmssZ" date/datetime formats
FEATURE: Query Analzyer & Popup menu: Added CTRL-SHIFT-DELETE short-cut for Clear Document.
FEATURE: Table Data Editor: Added File Menu with Hot-Keys
FIX: Table Data Editor & History Toolbars: Changed Toolbar button/icon to 16x16 instead of 20x20
FIX: Script Index CREATE: Multi-column Index would omit columns after the first one.
FIX: Grid Results: Formatting of Grid Results was broken in build 3.7.15
FIX: Import Tool: Informix 7.3 doesn't support quoted qualified columns
FIX: Query Analyzer in MultiTab results: Fixed focus of components as CTRL-TAB cycles through query windows.
FIX: 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)
FIX: 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
FIX: Import Tool: Importing files with spaces between comma separated columns (eg: column1, column2) would add a space to the beginning of column string data.
FIX: Schema Browser: Oracle Packages, Package Bodies and Java Sources. Queries are now based on ALL_OBJECTS.
FIX: Option "Do Not Prompt to Save For New Scripts": was not working when opening and creating new files.
FIX: Sybase Indexes: Extracting and Viewing didn't work for non-capitalized Indexes.
3.7.17: FEATURE: Query Analyzer: Added option in File->Options->[General] to enable MultiTab query results where the editor is the first tab and the results come after.
FEATURE: Window Menu: Added option to enable the toggling of the current Query Analyzers MultiTab/SplitPane mode.
FEATURE: CTRL-1 HotKey: Cycles through Query Window Results
FEATURE: CTRL-ALT-(RIGHT/LEFT ARROW) Focus back and forth between the Tree View and the Query Tab View
FEATURE: Grid Results: 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
FEATURE: Grid Results: Added option in File->Options->[Results] to specify alternating colors in grid results, including the option to set the background and foreground colors of the alternate row.
FEATURE: Query Editor and Text/History/Message Results: Added "Clear Document" option in the popup menu to clear all document text.
FEATURE: Text Results: Added option in File->Options->[Results] to enable/disable the displaying of the Warning headers along with the Warnings.
FEATURE: Query Analyzer Window: Added Window Menu with options to Hide/Unhide the Query Toolbar and Query Results.
FEATURE: Query Analyzer: Openning a Query Analyzer window will automatically set the current database according to the database selected in the schema browser
FEATURE: Application: When closing the application the Dialog prompt to Save files will also have "Discard All".
FEATURE: 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.
FEATURE: Popup menu on Query Analyzer tab now includes "Close All" and "Close Others"
FEATURE: Window Menu: Added option to Hide/Show application toolbar (CTRL-F8)
FEATURE: Schema Browser: Added to popup menu "Refresh" - F5 to allow a user to refresh the node without collapsing/expanding the node
FEATURE: Schema Browser: Added to popup menu "Script Object -> SELECT (*)" to Tables to generate a SELECT statement with '*' as the fields instead of the column names listed.
FEATURE: 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.
FEATURE: 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.
FEATURE: 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
FEATURE: 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.
FEATURE: Morph to Upper/Lower: The toUpper/toLower now do not change single or double quoted text
CHANGE: Introduce Value Stubs: For MS SQL Server and UniqueIdentifier datatypes, the value stub is now NEW() instead of ''.
FIX: Auto-Complete on Synonym columns stopped working after build 3.7.7
FIX: Auto-Complete: Bug which caused auto-completion to only show "Please Wait ..." and nothing else, now fixed.
3.7.16: FEATURE: Auto Completion: Supports customization of auto completion in File->Options->[Editor] ... Auto Popup, Auto Popup Delay, Instant Substitution, Maximumn Pane Size, Minimum Pane Size
FIX: Default for Instant Substitution in Auto Completion is now false
FIX: Auto Completion: Tab key now closes completion window after completing if there is only one item in the window.
FIX: Import/Export and Save Results Dialog: Added [Default] item for encoding types.
FIX: Sybase: Database Devices: Support for Visual Editing and Scripting of devices larger then 2G.
3.7.15: FEATURE: Option Dialog - Converted option settings to PropertyPanels
FEATURE: Syntax Coloring: Supports coloring of System Tables.
FEATURE: Syntax Coloring (File->Options->[Editor]): Added ability to enable/disable and set the syntax color for keywords, vendor keywords, datatypes, functions, system tables, comments and quoted strings
FIX: Execution of empty string when trying to change database on databases which don't have the concept of databases.
FIX: Generic JDBC/ODBC Connections: .setMaxRow() is not supported by some JDBC/ODBC drivers (SQLite) which caused ADS to fail on queries.
FIX: After closing last query window, give focus to Schema/Script Browser.
FIX: Postgresql: Script Function or Visual Edit Function incorrectly generated parameter type definition for datatype varchar by placing a '()' after the varchar.
FIX: Schema Tree: Move (Drag/Drop): You may now move servers to the root 'Database Server' node.
FIX: SQL Server/Sybase: Script Alter and Alter of Procedures/Functions which had comment blocks before the CREATE statement would not work.
3.7.14: FEATURE: Postgresql 8.0 - Visual Edit User/Role: Added permission options for tablespaces
FEATURE: Option Dialog: Changed the Tabbed View to an Outlook Tabbed View (aka Firefox/Intellij Option Dialog Look)
FEATURE: 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)
FIX: Oracle Schema Browser Table Node: Filtered Tables that start with BIN$ for Oracle 10g which are the tables in the Recycle Bin
FIX: Oracle Scripting Constraints: Added constraint state to the DDL which was being omitted for primary key, unique and check constraints.
FIX: Query Stats: Added hot key to enable/disable ALT-SHIFT-R;
FIX: Oracle Export Tool: Timestamp columns with precision would cause export to not work.
FIX: Large Resultsets/Out of Memory: ADS now has error checking for running out of memory while quering for very large resultsets
FIX: 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.
3.7.13: FEATURE: Added File->Options->[Results] tab with 4 options: Max display size of columns, Display Query Stats, Max retrieval size of BLOBs and Max retrieval lines of CLOBs
FEATURE: Added File->Options->[Editor] tab with 3 options: Expand Tabs to spaces, Number of Spaces in Tab expand and Size of Tabs. These settings allows for automatic Tab/Space conversion in the Editor
FEATURE: Syntax Coloring: Added Keywords for security related SQL statements
FEATURE: Postgresql 8.0 - Tablespaces: Added support for tablespaces: Schema Browser, Visual Editing and Scripting DDL
CHANGE: 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
CHANGE: Applied refactoring to source to enhance speed of key function calls and streamline database support infrastructure for new databases and database versions.
FIX: Oracle Scripting Foreign Keys: Added constraint state to the DDL which was being omitted.
FIX: Oracle Schema Browser: Added the "PUBLIC" schema folder in the schemas.
FIX: Oracle Visual Editor for Users/Roles: System Privilege list is now specific to the database version 8i/9i/10g
FIX: Oracle Visual Editor for Users/Roles Object/Column Permissions: Tables/Views/Columns have the appropriate index/references columns for User/Role and version type of database
FIX: MS SQL Server Visual Editor for Object Permissions: Separated Scalar and Tabular functions for permissions.
FIX: Index View Properties: Was displaying the datatype of the column incorrectly.
FIX: DB2 Schema Browser - Dependancies Node: Added query to include Procedures that are dependant on the table
FIX: Query Analyzer: Quering and displaying large BLOBs would lockup ADS.
3.7.12: FEATURE: Visual Editing for Security:
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
FIX: SQL Server schema browser, column node: Was displaying length of NCHAR and NVARCHAR twice the size.
FIX: Postgresql: Added support for Implicit Case-Sensitive schema objects
3.7.11: FIX: Mac OSX Look and Feel - Background of application was beening set to light gray.
FIX: 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.
FIX: Schema Browser for Oracle/Sybase Anywhere - Sorting Procedure and Function folder.
FIX: MS SQL Server Query Results: values of tinyint columns where being displayed incorrectly.
3.7.10: FEATURE: Schema Browser - 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.
FEATURE: Schema Browser - 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)
FIX: SQL Server Case Sensitivity: Stored Procedure & Function schema extraction and visual editing didn't work on SQL Servers with case sensitivity
FIX: Informix Queries on System Catalogs now explicitly query on the informix schema (eg informix.systables)
FIX: Informix Syntax Coloring: Added RESOURCES, STATISTICS, HIGH, MEDIUM, SUBSTR
3.7.9: FIX: CLOB data type: Multi-Line CLOB values were converted to single line values in Text Display and Import/Export Tool.
FIX: Table Editor for Postgresql - Numeric & Decimal types now support Precision and Scale.
FIX: Script Table CREATE for Postgresql - Numeric & Decimal types now support Precision and Scale.
FIX: MySQL & Postgresql: Import/Export Tool and Table Data Editor now escapes backslash to a double backslash when generating string values in INSERT statements
3.7.8: FEATURE: Browsing the Schema & Script browser with the keyboard will automatically scroll the pane to the selected entry.
FEATURE: Visual Table Editor for Sybase: Added ability to drop columns
FEATURE: Scripting Columns for Sybase: Added ALTER and DROP columns
FEATURE: 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=<full class path of Look and Feel>"
FIX: Table Editor for Oracle OCI connections: Didn't set the correct database and schema which prevented the creation of a table
FIX: Execute Explain (CTRL-Shift-Enter): was treating all comments as client side comments which removed Oracle Hints before execution.
FIX: Generic Schema Browser: Schema Filter wasn't working.
3.7.7: FEATURE: Export Tool: Tool allows user to export data results from query or table into delimited data or INSERT statements.
FEATURE: Schema Popup Menu: Now has Tools->Import/Export menu item for context sensitive import/export functionality.
FEATURE: Import/Export Tool: Scripting INSERT statements now has an optional statement separator for the script.
FEATURE: Import/Export Tool: Scripting INSERT statements now use the configured scripting options for identifiers and statement separator
FIX: View/Alter Table for DB2: Identity value was displayed incorrectly for columns with a column check constraint.
FIX: 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
3.7.6: FIX: MS SQL Server Script & ALTER View: Views over 4000 characters were trucated.
FIX: DB2 Column Check Constraints: Column check constraints created with GENERATED ALWAYS AS (CHECK) were not being scripted.
FIX: Look and Feel: Setting a Look and Feel not supported (e.g. Windows LaF on Linux) would prevent ADS from starting.
FIX: Visaul Editing Dialogs: Mapped the BACKSPACE ("Delete" on OSX) key to delete columns.
3.7.5: FIX: Import Tool: Import was removing "[" and "]" from strings in certain cases.
FIX: Table Editor [MSSQL Server]: UNIQUEIDENTIFIERS were not being single quoted when generating SQL statement
FIX: FIX: Block Syntax Coloring: Block Syntax Coloring was not terminating on "**/".
CHANGE: Query Analyzer Window: Now contains the name of the connection in the title.
CHANGE: Added ALT-D hot key in Query Analyzer window which gives focus to the Database Combo Box to remove the need to use the mouse to change database.
3.7.4: FIX: Create/Alter Table: Combo Boxes in detailed column info were not editable, such as "Default"
FIX: Import Tool: Negative numbers for numeric columns were being imported as positive values
FIX: Authentication Dialog when making a connection on registered servers without passwords saved, the username was disabled.
3.7.3: FEATURE: OSX Look and Feel: Added the ability to change the application font for the OSX look and feel. Default of Lucida Grande size 11
FEATURE: Schema Popup Menu now has the option "Query Analyzer as ..." which will prompt the user for a username/password before openning a connection for the Query Analyzer.
FEATURE: Schema Browser Table Node: Popup Menu now has the option "Table Data Editor (Top 1000)" to easily edit table data without writing SELECT statements and execute edit.
FIX: Oracle w/ Oracle 10g JDBC Drivers were getting the time of a DATE field truncated.
FIX: Stored Procedure Extraction: If Stored Procedure contained parameters with an opening '(' and no space before the procedure name, the '(' was truncated.
3.7.2: FEATURE: Integrated the Netbeans Editor v3.6 from v3.32
FEATURE: Added ALT-X hotkey to map to Execute
FEATURE: Auto-Completion is now threaded. Long running auto-completions display popup
with "Please wait" until completed, with the ability to cancel. (Feature in new Netbeans Editor v3.6)
FIX: Double Clicking on the last word in the text doesn't highlight (Fixed in Netbeans Editor)
FIX: Block Syntax Coloring: Block Syntax Coloring was not displaying correctly if a '/' was in the block comment.
FIX: PostgreSQL: Resultset returns NULL for CIDR datatypes.
3.7.1: FIX: Import Tool: The reported number of records imported on the status tab was one higher then actually imported.
FIX: Import Tool: Files with a blank line at the end of the file displayed a blank line in the sample record grid.
FIX: Import Tool: If CR/LF not included as part of the last line, the last character is truncated.
FIX: File->Options[Format] -> DataType formats where limited to the list.
FIX: Parser: If server side comments for "--" was enabled and disabled for "//" and a single quoted "/" was in the comments, the comment was truncated
CHANGE: Added the APPLICATIONNAME, PROGNAME and HOSTNAME connection parameters to SQL Server and Sybase connection types
so process info displays what application is being used.
3.7: CHANGE: Changed Version 3.5.25 to 3.7 for Packaged Release