Release History

Version 3.26.1 (05 Oct, 08)

• Fixed row count display for Sybase version 15.x
• Fixed issue when closing application with unsaved scripts
• Fixed Intellisense windows not positioned correctly on multi monitor systems
• Added extended stored procedures to Intellisense (Sybase, Microsoft Sql Server)

Version 3.26 (30 Sep, 08)

• Changed how DECIMAL and NUMERIC columns handled.
• Added back display of table row count. Now it's an option
• Intellisense support for multiple temp tables in Sybase
• Added ability to execute stored procedures and functions from Editor popup menu
• New and changed Admin queries
• ODBC connection improvements
• Small GUI changes

Version 3.25 (07 Sep, 08)

• Added option to not open connections when loading Session State
• Added option to automatically disconnect from Server after user specified time period
• Added option to commit or rollback when closing Oracle connections
• Added support for SQL User Defined Functions for Sybase 15
• Improved handling of temp tables for Sybase and Microsoft Sql Server
• Couple improvements for ODBC connections
• Fixed slow database change for Sybase ASE
• Fixed issue with not releasing DB2 locks in some rare circumstances
• Fixed issue with error lines not being indicated correctly for Sql Server
• Fixed issue with number formats for some locales when generating INSERT/SELECT/UPDATE
• Fixed issue with automatically committing changes when editing table data for Oracle and DB2 when AUTO COMMIT is off
• Enhancements and improvements in GUI, Editor and Results Grid

Version 3.24 (29 Jul, 08)

• Some Results Grid shortcuts were not working
• Fixed generate table script. Order of defaults, identity and constraints was wrong
• Fixed identifiers not being quoted correctly sometime
• Added diff options (case sensitive, ignore white space)
• Added menus for Quick diff
• Added ability to Edit / Delete Data Sources from Quick Connect
• More color options (variable and command colors)
• Intellisense list now shows table columns in create table order
• SQL execution history now persist between restarts
• Added option to copy column names with types and generate create table statement in Result Grid
• Fixed Shift+Tab working inconsistently

Version 3.23 (14 Jun, 08)

• Added support for Microsoft SQL Server 2008
• Added support for Oracle 11g
• Fixed error when using Oracle Client version prior to 8.1.xx
• Fixed Intellisense for Oracle stored procedures broken in previous release
• Enable multi line substitution values in Speed typing
• Improved Visual Diff interface. Faster diff algorithm
• New Quick Diff feature. Drag and drop text, script tab or result tab on a Quick Diff toolbar button to run diff between two items
• Minor GUI changes

Version 3.22 (22 May, 08)

• Fixed and added more options for multi selection in Object pane
• DBMS_OUTPUT was not working correctly in unicode version
• Remember current script directory for each server connection
• Fixed Replace Dialog hanging when doing replace all
• Fixed couple issues with Intellisense for DB2. Missing procedures, showing of system views
• BIGINT values now exported to Excel as text
• Fixed incorrect number formatting
• Some other minor changes and fixes

Version 3.21 (11 May, 08)

• Object Pane now allows multiple selections. Enabled copying from Object Pane by using keyboard
• Added ability to put results of every query to a new Result Tab (hold Shift key while executing query)
• Added ability to toggle ON/OFF limit for number of query result rows
• Fixed query results going to a wrong Result Grid
• Keyboard shortcut menu key now works correctly
• Fixed "Out of memory" error when selecting binary columns
• Generate SELECT includes only columns visible in Result Grid
• Long diagnostic messages not truncated anymore. Improved message formatting
• Fixed keyboard shortcuts conflicting with some keys on international keyboards
• Some other minor changes and additions

Version 3.20 (27 Apr, 08)

• Added option to enable multiple Result Tabs
• New option to display column types in Result Grid
• Find, Replace and Object Properties dialogs are not modal anymore
• Locale aware number display and new number formatting options
• Added option to script Oracle objects using DBMS_METADATA package
• Server Explorer was not correctly displaying DB2 and Oracle procedures
• Added option to display actual execution plan for Microsoft SQL Server
• Added missing Editor shortcuts for Ctrl+Backspace and Ctrl+Delete
• Some other minor changes

Version 3.19 (06 Apr, 08)

• Unicode version of SqlDbx Professional
• Removed option to connect to Microsoft Sql Server through DB-Library
• Small fixes and enhancements in different areas

Version 3.18 (02 Mar, 08)

• Fixed issue with intermittent locking of DB2 catalog views
• Fixed incorrect scripting of DEFAULT values and GENERATED BY columns for DB2
• Added ability to view BLOB's
• Added display of return values for Sybase stored procedures
• Fixed small scripting errors for Sql Server and Oracle
• Fixed display of unsigned values for Sybase Version 15
• Small GUI and Editor improvements

Version 3.17 (17 Feb, 08)

• Added multi line cursor insert/delete/type to Script Editor. Added shortcut key to set block selection on (Alt + C)
• Performance improvements in multiple areas (Export, Generate statements, Editor)
• Changed how table import/export works
• Small improvements and fixes in Editor, Excel export, Results Grid
• Fixed access violation when retrieving Oracle NCLOB columns
• Updated help file

Version 3.16 (05 Feb, 08)

• Added column (block) select/copy/cut/paste/drag/drop support to Script Editor
• Two new Paste options: Paste as block and Paste fill Selection
• Changed behavior for option "Results in Script Window". Now output goes to a separate window in a Results Tab
• Added option to capitalize names of procedures/functions
• BIGINT columns where not correctly exported to Excel
• Changed shortcut keys for BEGIN/COMMIT/ROLLBACK TRANSACTION
• Some other small fixes and changes: added menu to select active script window, added ability to rename unsaved scripts

Version 3.15 (15 Jan, 08)

• Added ability to directly execute Oracle package procedures and functions from Object View
• Added two new items to Editor popup menu: Script Object to new Window and Sync Object View
• Implemented explain plan for IBM DB2/UDB
• Fixed issue with favorite objects not being refreshed
• Couple scripting fixes for DB2 and Oracle
• Small changes in different areas: Editor, Results Grid, Quick Connect
• Added new shortcut key to switch between Editor and Results Grid (Ctrl + D)

Version 3.14 (06 Jan, 08)

• New feature: Quick connect
• Added more options to copy data from Results Grid and paste to Script Editor
• Fixed copy / paste to Excel
• Improved ODBC compatibility for some data sources
• Intellisense extended to work with temporary tables in MS Sql Server and Sybase ASE
• New command line options added: -q, -r, -w
• Minor scripting fixes for MS Sql Server, Sybase and DB2. Some minor GUI changes

Version 3.13 (16 Dec, 07)

• New features
     Sync Object View with Script Editor
     Added menu and shortcut keys for BEGIN, COMMIT and ROLLBACK TRANSACTION statements
     Added ability to switch AUTO COMMIT ON/OFF for DB2 and Oracle
• IBM DB2/UDB improvements
     Added support for DB2 UDB version 9.x
     Improved support for zOS and DB2 V7
     SQL parser now better handles DDL an DML batches and recognizes --#SET DELIMITER command. See help for more details
     Admin queries added for versions 8.x and 9.x
     Intellisense recognizes DB2 Aliases
• Improved IntelliSense
• Editor now correctly applies color to multi line literal strings
• Fixed issue with Sql Server and DB2 reporting an error when delete, update or insert did not affect any rows
• Some minor GUI improvements and usability enhancements. Slight changes to menu structure
• Fixed Results Grid print preview

Version 3.12 (15 Nov, 07)

• New feature: Transpose data in Results Grid
• Added configuration options for delimited file data exports
• Intellisense was not working correctly for DELETE statement
• Fixed handling of NULL values in Filter Grid Results
• Do not truncate trailing blanks for VARCHAR columns when copying from Results Grid
• Script variables values with spaces do not require quotes anymore

Version 3.11 (04 Nov, 07)

• New feature: Script variables. See help for details
• Significantly enhanced Speed Typing. Integration with Intellisense. Now supports substitution arguments
• Option to parse scripts for syntax errors without execution implemented for Sybase ASE and Sql Server
• Some other minor Intellisense and GUI enhancements and improvements

Version 3.10 (14 Oct, 07)

• Intellisense and Auto Complete now work across databases, schemas and owners. Enable it in Options->Editor->Intellisense
• Improved Intellisense. Now works in more cases
• Added ability to execute procedures and functions directly from Object View pane.
• Scripting for procedure and function execute now uses template parameters
• Added command line options. SqlDbx Pro only. See help for details
• Removed option to pre load packages for Intellisense for Oracle (not needed anymore). Fixed couple of bugs in Oracle SQL Parser
• Fixed issue with mixed case object names and names with embedded spaces for Oracle and DB2
• Generate INSERT/DELETE/SELECT now correctly handles string with embedded single quotes, binary columns and columns with NULL values
• Editor performance significantly improved for very long lines
• Fixed loading of incorrect system tables and views for SQL Server 2005
• Added shortcut to select SQL block (Ctrl+B). Shortcut for selecting text block changed to Ctrl+Shift+B
• Some other minor GUI enhancements and improvements

Version 3.00 (03 Sep, 07)

• Added ability import / export table data to files and Excel
• Improved support for international date formats in Generate SELECT/INSERT/UPDATE/DELETE
• Fixed issue with output messages sometimes not displaying correctly for SQL Server
• Fixed occasional freezing or termination of application while copying data from Result Grid
• Export to Excel of date and numeric columns does not depends on formats selected in Options anymore
• Some other minor GUI enhancements and improvements

Version 2.99 (21 Aug, 07)

• Added ability to create connection aliases
• Improved data diff
• Enhanced template management
• Fixed loading session state when using integrated security
• Some other minor improvements

Version 2.98 (06 Aug, 07)

• Fixed exception when accessing table properties in Sybase
• Fixed capitalize keywords option being always on
• Added option to manage file extensions

Version 2.97 (30 Jul, 07)

• Fixed saving / restoring of session state if using multiple computers on a network
• Fixed errors when creating Oracle triggers
• Improved Search in database
• Handle Oracle interval types
• Better handling of timestamp columns for Oracle and DB2
• Detect and reload files modified outside SqlDbx
• Added ability to use wildcards in Find and Replace dialogs
• Minor fixes and improvements. Some shortcut keys were not working. Missing keywords

Version 2.96 (03 Jun, 07)

• Enhanced Find and Replace dialogs
• Fixed couple small issues with Sybase and Oracle.

Version 2.95 (20 May, 07)

• Now each script tab has it's own associated set of results
• Redesigned results window.

Version 2.94 (12 May, 07)

• Fixed incorrect display of BIGINT values
• Significantly improved diff algorithm. Added ability to compare files
• Improved support for DB2 7.1 on z/OS. Fixed incorrect scripting of FOREIGN KEY constraints for DB2
• Fixed issue with expanding table columns for ODBC sources.
• Minor GUI enhancements. Improved Intellisense keyboard interface

Version 2.93 (29 Apr, 07)

• Added ability to save and restore user session state
• Display number of rows affected by INSERT, UPDATE or DELETE statements
• Intellisense improvements. Enhanced keyboard interface in results grid
• Improved Visual diff
• Fixed issue with inability to edit data in results grid for Sybase and SQL Server

Version 2.92 (05 Apr, 07)

• Added new Favorite Objects feature
• Improved support for Oracle and Microsoft servers
• GUI improvements

Version 2.91 (29 Mar, 07)

• Fixed date format bug introduced in previous release
• Some other minor fixes

Version 2.90 (18 Mar, 07)

• Microsoft SQL Server 2005 support
• Added ability to apply filter in results grid
• Added support for quoted Identifiers
• Generate SELECT statement from results grid. Show table constraints in tables pane
• Some other minor fixes

Version 2.89 (04 Mar, 07)

• Significantly improved support for ODBC sources
• Added support for Sybase Version 15
• New Auto Complete feature implemented. It can be configured in Editor Options
• Multiple Oracle homes support

Version 2.88 (18 Feb, 07)

• Intellisense changes
      System tables, views and procedures can be added to Intellisense. Options->Editor->Intellisense
      New auto suggest feature. Default shortcut key Ctrl+SPACE. Very basic at this time
      No popup lists and keyword capitalization inside comments
• SQL History feature completely redone
• New Quick search in script feature added
• More DBA related queries
• Fixed some menu and keyboard shortcuts
• Some minor GUI changes.

Version 2.87 (07 Feb, 07)

• Added handling for even more data types for SQL Server and DB2
• Intellisense now works with procedures and functions in Oracle packages. You can add packages to be included in Intellisense
• Fixed some accelerators keys not working in certain conditions
• It's now possible to set values to NULL when editing table data
• Some other minor enhancements and performance improvements in various areas

Version 2.86 (15 Jan, 07)

• Added handling for more data types (SQL Server : BIGINT, BINARY, VARBINARY. DB2 : BINARY, VARBINARY)
• Added option to select alternative background and text color for database connections
• Copy to clipboard now works in Messages tab
• Locale specific default date and time formats
• Added ability to set column formats directly in Results Grid
• Some other minor enhancements and performance improvements

Version 2.85 (11 Dec, 06)

• Intellisense and UI improvements
• Added option to print selection in results grid
• Minor fixes and enhancements

Version 2.84 (29 Oct, 06)

• Intellisense improvements. Table aliases recognized. DELETE and UPDATE statements supported. List of columns shows after WHERE and SET clauses
• Display query plan and query statistics for Sybase, Oracle and SQL Server
• Alternative window layout option added
• Improved search in object pane of script editor
• Fixed file saving to CSV and XML
• Fixed connect / disconnect without closing script editor
• Minor fixes and improvements in script editor

Version 2.83 (14 Aug, 06)

• Allow to directly modify table data in result grid for tables with unique constraints
• Option to limit number of returned rows. Option to see totals for numeric columns
• Fixed scripting of Sybase triggers
• Enable multiple selection in result grid. Copy and Generate statements use multiple selections.
• Generate WHERE IN (...) expression from result grid
• Minor improvements in editor, drag and drop, file handling

Version 2.82 (04 Jun, 06)

• More accurate indication of compile error lines for all Servers
• Fixed incorrect scripting of unique constraints for Sybase and Microsoft Servers
• Fixed issue with object dependencies not being displayed correctly
• Fixed incorrect parsing of CASE and OPEN PL/SQL statements for Oracle
• Automatically display compile errors for Oracle

Version 2.81 (29 May, 06)

• Improvements to DB2, Sybase and Oracle scripting
• Added ability to dynamically connect / disconnect from Server

Version 2.80 (4 Apr, 06)

• Support for code templates
• Generate INSERT, UPDATE, DELETE from Results grid
• Support for new data types in Oracle 10g
• Improvements to IBM DB2 support

Version 2.70 (3 Feb, 06)

• SQL Editor improvements.
• Speed Typing
• Initial support for Microsoft SQL Server 2005

Version 2.60 (16 Nov, 05)

• Object scripting improvements
• Discovery of available Servers

Version 2.50 (15 Jul, 05)

• Initial support for IBM DB2
• DBA style queries added

Version 2.00 (8 Jan, 05)

• First public release of SqlDbx