3.0.29: FIX: OSX CTRL/Apple Hot Keys - All CTRL hots keys are now mapped to Apple hot keys. The CTRL-C/X/V/Z and Delete keys in the editor work correctly
FIX: Query analyzer - double clicking on a word containing underbar characters doesn't highlight the entire word
3.0.28: FEATURE: Scripting - Added Scripting for Sequences on Oracle and Postgresql
FEATURE: Scripting - Added Scripting for Packages and Package Bodies for Oracle
FEATURE: Support for Synonyms & Aliases in Informix & DB2 ... Describe, Table Editor, Auto-Completion and SQL Automation now supports Synonyms/Aliases
FEATURE: Added following Option settings:
1. History - Option for specifying the max # of lines in the text history results
2. History - Option for specifying the max # of lines in the text message results
3. Scripting - Option for identation size on scripting DDL and DML
4. Scripting - Option for Statement separator {GO, /} in multi statement DDL and DML scripting
5. Scripting - Option for specifying the Quote Identifier for objects in the DDL and DML scripting "",[]
6. Scripting - Option for Fully Qualifing object with schema in DDL and DML scripting
7. Comments - Option for specifying which comments are Client & Server Side Comments: --, // or /* */
FIX: Saving a file when closing a Query Window would fail. Fixed.
FIX: Saving a file with Save As or creating a new file, would not append a default 'SQL' extension if the user didn't specify an extension.
3.0.27: FEATURE: Scripting - Added Scripting for Databases on Sybase, SQL Server, Informix, Postgresql and MySQL
FEATURE: Informix - Added KEYWORDS to syntax coloring ... RENAME, MODIFY and TO
FEATURE: Save Results - Added option to allow user to specify the line-divider to be 'Windows (CR/LF)' or 'Unix (LF)', with 'Windows (CR/LF)' being default on Windows and Unix on all other platforms
3.0.26: FEATURE: Scripting - Added Scripting for User/Group(Roles) for Sybase, MS SQL Server and Informix
FEATURE: Scripting - Added Scripting for Defaults/Rules on Sybase and SQL Server and Rules on PostgreSQL
FEATURE: Oracle 9i - Support for the new TIMESTAMP/TZ/LTZ data type
FIX: Execute Edit worked on the entire current statement. Now, it works on the selected text first ... and the current statement if nothing is selected
3.0.25: FEATURE: Scripting - Added Scripting for Synonyms/Aliases on DB2, Informix and Oracle.
FEATURE: Schema Browser Synonym/Alias Node - Added the name of the corresponding object to name of the node
FEATURE: Data Type Scripting on DB2, Informix, Sybase Anywhere, Sybase, SQL Server, PostgreSQL
FEATURE: Schema Browser Data Type Node - Added the name of the corresponding base datatype
FEATURE: Syntax Coloring - Added keywords for Synonym/Alias/Data Type scripting
FEATURE: Syntax Coloring - Added a more complete list of keywords for MySQL
FIX: Informix Server Registration - If database registered was not sysmaster, then Query window would not open.
FIX: Sybase Stored Procedure Parameter node didn't show parameters of the stored procedures.
3.0.24: FEATURE: Sybase Anywhere - Added 'System Tables' and 'System Views' nodes to the Schema Browser on Sybase Anywhere.
FIX: Sybase Anywhere - Column and Table names are trimmed for metadata queries in auto-completion and schema browser for Sybase ASA 6.x
3.0.23: FIX: If a script is being modified and another script is double-clicked for open, there is no prompt to save the current script.
FIX: The first click on grid results column now sorts the column in ascending order instead of descending.
FIX: If no Primary Key or Unique Constraint is defined on table being edited, then user is not prompted to select one
FIX: "Message" Results tab did not have the display set to the last appended message in the document. Now display is always set to the bottom.
FIX: Build 3.0.22 introduced bug which didn't allow the saving of results ... FIXED
FEATURE: Added support for Openning and Saving files in different Encoding types
FEATURE: Added support for new Encoding types for Saving Results and Files, to include all of the following ...
"ASCII - (American Standard Code for Information Interchange)"
"Cp1250/Windows-1250 - (Windows Eastern European)"
"Cp1251/Windows-1251 - (Windows Cyrillic)"
"Cp1252/Windows-1252 - (Windows Latin-1)"
"Cp1253/Windows-1253 - (Windows Greek)"
"Cp1254/Windows-1254 - (Windows Turkish)"
"Cp1257/Windows-1257 - (Windows Baltic)"
"ISO 8859-1 - (Latin Alphabet No. 1)"
"ISO 8859-2 - (Latin Alphabet No. 2)"
"ISO 8859-4 - (Latin Alphabet No. 4)"
"ISO 8859-5 - (Latin/Cyrillic Alphabet)"
"ISO 8859-7 - (Latin/Greek Alphabet)"
"ISO 8859-9 - (Latin Alphabet No. 5)"
"ISO 8859-13 - (Latin Alphabet No. 7)"
"ISO 8859-15 - (Latin Alphabet No. 9)"
"KOI8-R - (Russian)"
"UTF-8 - (8-bit Unicode Transformation Format)"
"UTF-16 - (16-bit Unicode Transformation Format)"
3.0.22: FEATURE: Performance - Memory consumption decreased by ~33% on Queries and Speed Increased on Queries.
FEATURE: Scripting - Added Scripting for Indexes and Constraints, including constraints for Table Scripting
FEATURE: Syntax Coloring - New Keywords related to Constraint and Index Scripting
FEATURE: Schema Browser Top Index Node - Added the name of the corresponding table to name of the node
FEATURE: Schema Broswer Index Node - Added columns node to specify the columns in the index and sorting order
FIX: DB2 Schema Browser - Table Index Node did not include all indexes.
FIX: Query Analyzer Popup Windows were being reclosed when closing ADS, causing a double prompt to save working data.
FIX: Top File Menu (Automate) - Converted Mnemonic to "A" - "Execute Parse" hot key changed to Ctrl-Alt-A
FIX: Current Result Tab was not saved on requeries when "History Text" is the currently viewed tab
3.0.21: FIX: Printing on OSX failed to print
FIX: When closing a query window and prompted to save the file, if Save As is selected but then cancelled, the query window will closed. Now the window does not close.
FIX: Changed Query Timer format in Query Analyzer to hh mm ss
FIX: Changed the default max history for SQL history to 5 (from 0)
3.0.20: FEATURE: Added Constraint Node in the Schema Browser (under the table node) for Informix, MySQL, Oracle, PostgreSQL, Sybase Anywhere
FEATURE: Added Print capabilities from the Query Analyzer. You may print SQL Scripts and SQL results with the CTRL-P hot key
3.0.19: FEATURE: Query Analyzer Window - Allows user to open a separate frame window for Query Analyzer
FEATURE: Text Result History - a text result panel which displays continues to append the text results to the previous results
FIX: When saving query results, the encoding used is saved as the default encoding for future saves.
FIX: Introduce Columns, Qualified Columns, Value Stubs on SQL Server and Postgresql didn't work when operating on a table that wasn't owned by the user logged in.
3.0.18: FIX: PostgreSQL 7.2.x - Script SELECT, CREATE and DROP didn't work
3.0.17: FEATURE: ADS now support DBMS_OUTPUT for Oracle by displaying the output in the text results. You may enable/disable it on the main toolbar
FEATURE: Full support for PostgreSQL 7.3 and above
FIX: Table Editor didn't work on PostgreSQL 7.3 and above.
FIX: Made the top toolbars non-floatable.
FIX: Select All and Copy to clipboard from grid results didn't work very well with large resultsets.
FIX: ADS was not cancelling any running queries when exiting. ADS now cancels all running queries before exiting.
3.0.16: FEATURE: When executing a query, the status bar now includes a [real] time elapsed executin time of the query.
FEATURE: Optimized the speed and memory of query execution with text results. Text results take up less memory and display much faster
FIX: When registering a Server, the server name allowed users to specify special characters. The server name must be a valid filesystem name. This would cause ADS to fail. ADS now prompts the user.
FIX: Table Editor for MySQL 4.0 didn't work for tables that were not all uppercase ... because of MySQL's case sensitivity.
3.0.15: FIX: Option Dialog didn't come up if there was a problem retreiving Fonts from the OS (specifically on OSX).
FIX: Table Editor on SQL Server had editing of the TEXT datatype disabled ... now it is enabled
3.0.14: FIX: SQL Server and Sybase allow for Databases with Spaces, but ADS didn't support them ... now ADS supports them.
FIX: DDL Trigger scripting for Sybase didn't retreive full source for large triggers.
FIX: DDL Trigger scripting for Microsoft SQL Server didn't retreive full source for large triggers.
FIX: DDL Procedure & Function scripting for Informix didn't retreive full source for large sources.
FIX: DDL & DML Scripting for Views didn't work for Sybase
FIX: DDL & DML Scripting for System Tables on MS SQL Server didn't work.
FIX: Removed Square Icon from first column of the grid results that specified the grid was not sorted.
3.0.13: FIX: DDL Scripting for Microsoft SQL Server Functions and Stored Procedures. CREATE and ALTER didn't work. Now Fixed.
3.0.12:- FEATURE: Trigger, Procedure and Function nodes in Schema Browser now support DDL scripting for CREATE, REPLACE, ALTER and DROP
FEATURE: Schema Browser: Top level Trigger Folder now contains Trigger nodes with the Table name which the trigger is on.
3.0.11:- FEATURE: Table Editor now supports UNIQUE constraints. If there is no Primary Key, then a UNIQUE constraint is used for setting the primary keys.
FEATURE: View Node in Schema Browser now supports SQL DML and DDL for SELECT, CREATE and DROP
FEATURE: Sorted the Database/Schema Object Nodes in the schema browser in a consistent manner across databases in priority of important (Tables, Views, Synonyms/Aliases, Indexes, Triggers, Procedures, Functions ...)
FEATURE: Informix Schema Browser: Added Function and Top Level Indexes Folder
FEATURE: Postgresql Schema Browser: Added Function and Top Level Indexes Folder
FEATURE: MS SQL Server Schema Browser: Added Top Level Indexes and Triggers Folder
FEATURE: Sybase Schema Browser: Added Top Level Indexes and Triggers Folder
FEATURE: Sybase Anywhere Schema Browser: Added Top Level Indexes and Triggers Folder
FIX: Table Editor on Sybase only allows a save once, and then fails on any other attempts.
FIX: Script Parser removed comments within quotes (eg 'LK--%', the parser would remove --%'), now fixed.
FIX: Generic-JDBC driver - Schema Browser would not show Tables and Procedures if the database didn't support Schemas, now fixed
3.0.10:- FIX: Script Table Create on Oracle didn't always put the precision and scale for NUMBER data type
FIX: Account for null JDBC Driver MetaData when connecting to a server
3.0.9: - FEATURE: Table Node in Schema Browser now supports SQL DML and DDL scripting for SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER and DROP
FEATURE: Auto-Describe now supports Identity info for databases supporting Identity data type.
FIX: Informix 7.3 - Index folder for tables in Schema Broswer did not show the Indexes.
3.0.8: - FEATURE: Execute Edit / Table Editor - Now supports PUBLIC Synonyms for Oracle
FEATURE: Column Auto-completion now supports PUBLIC Synonyms for Oracle. Table Auto-completion will NOT
display PUBLIC Synonyms because there are too many default defined PUBLIC Syononyms by Oracle.
FEATURE: SQL History
3.0.7: - FEATURE: Table and Column Auto-completion now has support for Synonyms.
FEATURE: Table Editor/Execute Edit now supports Synonyms. If you execute edit on a Synonym it will edit the table the Synonym maps to
FEATURE: Auto Describe now supports Synonyms
FEATURE: Introduce Columns, Qualified Columns and Value stubs now support Synonyms
FIX: In 3.0.6 if you tried to close the application it would not close. [Only if you downloaded an early build]
FIX: If Table Editor is invoked on a SELECT statement which doesn't select the Primary Key, then execption was thrown when trying to save changes. Warning is now displayed.
FIX: Removed debugging info being printed on console/terminal window
3.0.6: - Windows Authentication and Trusted Connection support:
- New connection types. SQL Server 2000 - ODBC, SQL Server 7 - ODBC and Generic - ODBC. With these connection types
- you may connect to SQL Server using Trusted Connections
FIX: In Table Editor, if a cell was changed, then cleared, then changed again, the data would be set to null
3.0.5: - FEATURE: Added "Select All" to the popup menu of the Grid Results which selects all the rows in the grid
FEATURE: While executing a script or statement, the status bar now shows more detailed status of the status of the execution
FEATURE: The initial focus at application startup is now the schema tree
FIXED: "Copy" in the popup menu of the Grid Results only worked when there was one grid result.
FIXED: If OS Environment doesn't contain USER_HOME variable then ADS would not be able to save any settings and would not run. ADS now prompts the user to set the USER_HOME
FIXED: OSX - The header on the Grid column looked funny. Fixed, and also changed icon to a black arrow.
3.0.4: - FIXED: Informix column auto-complete was padding the name to 18 characters. Now the column name is trimmed.
FIXED: MySQL v 4.0 database names are case sensitive, and 3.x are not. Made ADS current database support for MySQL case sensitive.
FEATURE: Opening a Query Analyzer window sets the current database to the database currently being browsed on the schema tree.
FEATURE: Tabs now have an X button to close an individual tab
3.0.3: - Added Copy command to right-click menu on Grid results.
- When auto-commit is enabled, the commit and rollback buttons are now disabled.
- Made result pane smarter. If message tab is the current tab but no messages then show text or grid. If grid is current, but has no results, then show text or message tab.
- Added all SQL92 Keywords to Syntax Coloring for all databases types
- Testing the Query Analyzer cancel button on sample databases. Trying to cancel a query while waiting on the database server to return from an executeQuery() command.
Oracle 8i/9i - WORKS
Postgresql - WORKS
Sybase Anywhere - WORKS
Informix - WORKS
Sybase - WORKS
MS SQL Server 7.0 - WORKS
MS SQL Server 2000 - WORKS
MySQL - doesn't cancel
DB2 7.1 - doesn't cancel
DB2 8.1 - doesn't cancel
- Added Option to change the font of the SQL Editor
- Shell scripts, change the line: ADS_HOME=. into: ADS_HOME=`dirname $0` for datastudio.sh and datastudio-bundled.sh
- Fixed SQL Server and Sybase schema resolution. If <USERNAME>.TABLENAME doesn't exist, then use dbo.TABLENAME
- When Register a MySQL Server, the default database is set to 'mysql' if one is not specified
- Display error when unable to change current database.
- Support for Informix 7.3 by not quering on sysxtdtypes table for schema extraction
- OSX - File->Exit (Alt-F4) is now File->Quit (Meta-Q) on OSX
- OSX - Made the default fonts for OSX: Editor: Monaco/10 Text:Monaco/10 Grid:Helvetica/12 which are more readable
- OSX - Buttons in dialogs now look like OSX buttons for OSX Look and Feel
- OSX - Buttons in dialogs are now centered for OSX Look and Feel.
3.0.2: FIXED: Sybase Table Editor only worked on tables with all UPPERCASES.
FIXED: Fixed some more issues with connecting to Sybase database with Roman-8 character set.
FIXED: Postgresql TEXT datatype was not editable.
3.0.1: Enabled Execute Edit button to enable the Table Data Editor
--- Start 3.0 ---
DB Support
-------------
1. Native Support for Informix Dynamic Server 9.3
2. Native Support for Sybase Anywhere 8.0
Options
--------------
1. Ability to select which fonts to use in the application
2. Ability to specify Look and Feel of the application, including native OSX Look and Feel
2. Ability to specify the default behavior on saving passwords for registered servers
Register Server
----------------
1. Allow multiple file selection with the browse button and to save the previously selected directory for Gen-JDBC.
2. Option to not save password ... (this does not store the password on disk or memory)
3. Added Driver Parameter Option for Sybase 12.5 and Sybase Anywhere, this is to be used when connecting to a Sybase Server with Roman 8 Character set with a driver param of ?charset=iso_1
SQL Writing Automation
------------------
1. Introduce Select Stmt - This will insert a new SELECT statement and place the cursor to the table postion
2. Introduce Insert Stmt - This will insert a new INSERT statement and place the cursor to the table postion
3. Introduce Update Stmt - This will insert a new UPDATE statement and place the cursor to the table postion
4. Introduce Delete Stmt - This will insert a new DELETE statement and place the cursor to the table postion
5. Introduce Columns - This will insert a list of columns for the tables in the current query
6. Introduce Qualified Columns - This will insert a list of fully qualified columns for the tables in the current query. If the tables are aliased the the table name will be the alias.
7. Introduce Value Stubs - This will insert a list of value stubs for the columns of the tables in the current query. '' for CHAR values, 0 for numeric values and NULL for all others.
8. Comment Statement - This will comment out the current statement by wrapping with /* */
9. Comment Line - This will comment out the current line with a //
10. Uncomment Comment - This will uncomment the current comment, by removing the /* */, // or the -- slash comments
11. Morph To Upper Case - This will convert the current statement to upper case
12. Morph To Lower Case - This will convert the current statement to all lower case.
13. Delete Word - Ctrl-Backspace will now delete the current word
Query Analyzer
--------------
1. Ability to have files with no extension show up in the script browser (currently exceptions are thrown)
2. Right-click Query Analyzer analyzer should open on the server even if a child is selected just like server properties.
3. Have the subsequent queries select the tab that was previously selected. So if Grid is selected and a query is executed then the Grid tab is now selected.
4. SQL Prediction puts ( ) for set values in an UPDATE Statement ... ( ) removed
5. If "Text Results" are disabled and a query is executed which does not return any results, then set the focus to the "Messages" Tab.
6. Added Syntax Coloring for all Built-in Functions with dark green
7. Ability to sort table columns. You may sort grid results by clicking the column, alternating between ascending, descending and no-sort.
8. Added Query Analyzer Clone (Ctrl-Shift-Q) - This will open a new Query Analyzer with a new connection using the same settings as the current Query Analyzer
9. Grid Results - You may now select individual cells, individual rows by row number and columns by column header
10. Added Row #'s to the rows in the grid
11. ADS now sets the .setMaxRow() on a Statement before executing an SQL Statement
12. Stop Button now works on long running queries on the database server.
Installer & Packaging
----------------------
1. OSX - Packager and Launcher - You may now launch the OSX installed application by double clicking on an icon.
Save Results
------------------------------------------------
1. When selecting a file and there is no extension, an extension will be added according to what data format
is currently selected. ".txt" for delimited text, ".html" for HTML and ".xml" for XML files
Choose Server
------------------
1. Refresh the servers when openning the Dialog.
Miscellaneous
--------------
1. Ability to hide the left browser panel
2. Remember the "last SQL Directory opened" for mounting directories, saving results and saving files
Bugs
-------------
1. Bug: The text results page loses text clarity if scrolled horizontally
2. Bug: Ctrl-Describe has an alignment problem on "smalldatetime"
3. Bug: Syntax Editor: UPDATE "update EMPLOYEE set EMPLOYEEID=1, FOLDERID=2, NAME='d' where " the quoted text is not red
4. Bug: Describe Query when there is no query generates a stack trace
5. Bug: Quoted text with N for NVARCHAR (eg: N'My Text') doesn't make the quoted text red. fixed.
Schema Browser
--------------
1. If you right-click on the schema window it popups up the window but doesn't select the node.
2. Oracle - Display management and other folders even if the user doesn't have access to them.
3. Added Folder for Triggers to Sybase
4. NOTE: Generic-JDBC Connections don't refresh the metadata. It seems most drivers do this because of performance reasons. I can't change this :( This is driver specific.