Release History

Version 3.53(12 Feb, 12)

New and changed features

• Improved error reporting (Oracle)
• New Shortcut keys ALT+1, ALT+F3
• Multi sheet export to Excel
• Performance improvements (Excel export. Data compare)

Fixes

• Database combo box empty (Sybase 11)
• Error connecting using ODBC
• Horizontal scrolling using mouse
• Main menu not displayed correctly in SqlDbx x64
• Arithmetic overflow in Databases admin query (Sybase)
• Intellisense drop down shows columns from unrelated table

Version 3.52(04 Dec, 11)

New and changed features

• Support for DB2 iSeries version 7.x
• Direct Oracle connection
• Informix synonyms
• Filter option to hide rows in Result Grid
• New and updated Admin queries (Sybase, Sql Server, DB2)
• Copy as text in Result Grid option
• Display count in Search Database dialog

Fixes

• XML type columns not displayed (Oracle)
• Closing Results window exits SqlDbx
• Unable to move Grid columns
• Intellisense fix for table aliases
• Single quote not escaped in Generate SELECT / DELETE / UPDATE
• String quoting in SqlDbx Unicode
• Do not display IN parameters when executing stored procedures (DB2)
• TRUNCATE TABLE menu does not work (DB2)
• Missing stored procedure properties (DB2 z/OS)
• Do not display auxiliary tables (DB2)
• Execute and Script Execute stored procedures fails (DB2 z/OS)
• Incorrect scripting of DROP for materialized views (Oracle)
• Incorrect scripting of GRANT for functions returning table

Version 3.51(25 Sep, 11)

New and changed features

• Informix support (Pro Edition)
• Improved support for PostgreSQL
• New script commands (Pro Edition)
• Simplified scripting for stored procedures execution (DB2, Oracle)
• Import table data from CSV file (Pro Edition)
• Option to disable / enable whole script execution
• Option to display results in a new grid
• Extended password security support (Sybase ASE)

Fixes

• Truncation of long character columns (DB2, SQL Server, ODBC)
• Unicode version uses too much memory
• Intellisense fixes
• Incorrect lower/upper keyword case in some instances
• Unhandled exception in editor when moving line up / down
• Incorrect Intellisense parameters for stored procedures (MySql)
• References loaded for wrong schema
• Export to CSV with no delimiters right trims VARCHAR columns

Version 3.50(24 Jul, 11)

New and changed features

• SqlDbx portable version
• Schema compare (Pro Edition)
• PostgreSQL support
• Improved MySQL support
• Scripting improvements (DB2)
• Connection to uncataloged databases (DB2)
• Better error reporting

Fixes

• Fixed issue with Oracle parser
• Disable ODBC escape sequences
• Disable not implemented menus and toolbar icons
• Results in Grid / Text option not handled correctly
• Blank DATE or TIME columns
• Incorrect MONEY columns display precision (Sybase ASE)
• "Rerun Query" executes wrong query

Version 3.49(03 Apr, 11)

New and changed features

• Svn integration (requires TortoiseSVN)
• Quick Diff for Objects
• Improved scripting (DB2)
• Support for IN and INOUT stored procedure parameters (DB2)
• Additional functions in Result Grid: AVG, COUNT
• Option to set color of active line
• Move current line up / down (CTRL+SHIFT+UP / CTRL+SHIFT+DOWN)

Fixes

• Intellisense displays incorrect table columns for tables with the same name in different schemas (SQL Server)
• Compilation errors not displayed (Oracle)
• Handle invalid dates (Oracle)
• "Scripting Options" dialog displayed multiple times
• Multiple fixes for x64 version
• Procedure source not shown correctly (Sybase IQ, iAnywhere)
• Missing precision for DATETIME2 and TIME columns (SQL Server)
• Exception when exiting with results windows open
• Fixed incorrect display of UNIVARCHAR and UNICHAR columns (Sybase ASE)
• Exception when pasting text from other applications
• Incorrect system views used for some catalog queries (Oracle)

Version 3.48(27 Jan, 11)

New and changed features

• Added Production and Non Production mode
• Option to set restrictions for production mode (Options->Servers)
• Added predefined variables $(TODAY), $(NOW), $(CURRENT_SCHEMA)
• Script to Clipboard
• Added option to truncate tables
• Significantly improved Workspace / Session management
• Minor UI changes

Fixes

• Object list empty for case sensitive server installations (Microsoft Sql Server)
• Generated permission statements missing separator (IBM DB2)
• Generated SELECT / UPDATE / DELETE missing second fractions for some Date types
• Some UI elements not updated correctly when switching between connections
• Diff view displays identical lines as changed
• Line numbers missing in Messages Tab
• CLR functions not displayed in function list (Microsoft SQL Server)
• Line numbers missing in Messages Tab
• Erroneous scripting of permissions for triggers
• SqlDbx window not visible when performing Alt+TAB

Version 3.47 (17 Oct, 10)

New and changed features

• Schema / Database filter
• Script commands
• Changed log options and log format
• Added option to script USE (Sybase, MS SqlServer)
• Editor option to untabify selection in Editor
• Changed how new script tab names generated
• Changed behavior of some shortcuts keys in Editor and Results Grid (HOME, END, PgUp, PgDown, Ctrl+D)
• Some minor usability improvements

Fixes

• Exception when loading session state from unavailable network share
• Drop menu in Object Pane not working correctly when selecting multiple items
• Unable to connect to Sybase ASE when certain database administration tasks running
• Temp tables column not showing in Intellisense (Sybase, MS SqlServer)
• Incorrect scripting of GRANT TO PUBLIC
• Result Grid mode reset after each query
• Editor is not responsive in certain situations

Version 3.46 (18 July, 10)

New and changed features

• MySQL and Kdb+ support
• Improved Intellisense
• Added support for ALTER table statements
• Scripting to new tab when SHIFT key is pressed
• ODBC improvements (Indexes, primary / foreign keys)
• Added ability to use ODBC drivers for some database systems without creating DSN entries
• SQL Forms
• Scripting to new tab when SHIFT key is pressed

Fixes

• Long table constraints truncated (Sybase)
• Incorrect number of affected rows by stored procedure (Sybase)
• Inconsistent Editor behavior for some shortcut keys
• Incorrect lower/upper keyword case in some instances
• sp_procxmode not scripted for stored procedures (Sybase)
• Search in Results not working for some locales
• Couple small scripting errors
• Exception when closing ODBC connections

Version 3.45 (09 May, 10)

New and changed features

• Generate SELECT / INSERT / ... uses SQL formatter settings (SqlDbx Pro only)
• Additional color options
• Ability to "Mark" up to three different words
• Export Results grid selection to CSV, XML
• Additional date formats

Fixes

• Table columns not sorted in Intellisense window
• Table names missing owner (Sybase Anywhere / IQ)
• Incorrect table scripting (IBM DB2 for z/OS)
• Timeout connecting to DB2 on iSeries
• x64 version access violation when pasting from clipboard
• Spaces not handled correctly when using substitution variables

Version 3.44 (04 Apr, 10)

Fixes

• Keyboard menu accelerators not working for languages other then English
• Errors when performing operations on multiple selected objects in Object list
• Unicode version does not connect to DB2 in Windows 7
• Open multiple files sometimes does not open all files
• No results when truncating text columns for Sybase
• Incorrect behavior when selecting multiple objects in Object list
• Incorrect scripting of constraint columns for Sql Server
• Incorrect case for user types in Sybase and Sql Server
• UNICODE files not loaded correctly

Version 3.43 (7 Mar, 10)

New and changed features

• Support for multiple languages (Pro version only)
• Updated system queries for DB2
• Intellisense improvements
• Enhanced Object list view
• Info tips in Object list view
• Two new scripting options
• Floating windows layout saved / restored
• Option to select DBA or ALL catalog views for Oracle
• Option to group objects by user for Sybase IQ / Anywhere
• Separate ANSI settings for different Sybase products
• Small changes and improvements

Fixes

• Error connecting to Oracle 8.1.x
• BEGIN / END blocks not matched correctly
• Toolbar combo boxes not working on Windows 2000
• Inconsistent menu items and shortcuts
• Slow export from Excel
• Exception for ODBC connections
• Reduced windows resources usage
• Exception in Editor
• Bad formatting of END statement

Version 3.42 (11 Jan, 10)

New and changed features

• SQL Log
• Upper / Lower case scripting
• Support for script / execute functions (Sybase Anywhere / IQ)
• Enhanced scripting formatting
• Improved handling of script variables
• Keyboard shortcuts to switch focus between different windows (Ctrl+1, Ctrl+2, Ctrl+3)
• Improved keyboard navigation
• Multiple small improvements in Editor

Fixes

• Incorrect cursor position after search
• OUT parameters for SQL Server not scripted correctly
• Crash during restoring saved session
• Editor crashes when using bookmarks
• Inconsistent keyboard shortcuts

Version 3.41 (06 Dec, 09)

New and changed features

• Hide / Show lines in Editor
• Template manager replaced by File browser
• Initial support for Sybase IQ 15
• Associate files with SqlDbx
• Added date and time to SQL statement history
• Added option to only generate update statement when editing table data
• ANSI version can read UNICODE files
• Small changes and improvements in different areas

Fixes

• Intermittent x64 version crashes
• Computed table columns were not scripted correctly for Sybase and SQL Server
• Long passwords truncated
• Oracle XMLType limited to 2K
• Session state not restored correctly in some instances
• File save dialog missing ANSI / UNICODE combo box on Windows 7
• SqlDbx Unicode version not connecting to SQL Server on Windows 7

Version 3.40 (18 Oct, 09)

• Native x64 version of SqlDbx
• Added multi column Results grid sort (Ctrl + double click)
• Added support for Oracle XMLType column
• Improved support for multiple Oracle Homes
• Improved Table Export to file
• Improved Insert New Row feature. Better handling of identity and timestamp columns
• Fixed scripting of defaults and check constraints for Sybase and Microsoft SQL Server
• Fixed painting issues on Windows 7
• Fixed inconsistent DB2 connect behavior
• Small improvements and enhancements in couple different areas

Version 3.33 (13 Sep, 09)

• Added ability to modify table data and generate UPDATE/INSERT for ODBC Connections
• Improved support for Aliases / Synonyms for DB2 and Oracle
• Improved Intellisense: display primary / foreign constraints for JOIN statement
• Multiple improvements for DB2 scripting. Better support for DB2 iSeries
• Displays execution time for each individual batch
• Added data modify update statements to SQL History
• Added option to toggle Editor column mode (ALT+C)
• Added some missing menu items
• Fixed Modify Table Data generating incorrect update statement
• Fixed exception when generating UPDATE statement for Sybase
• Fixed Cascade / Tile not working
• Fixed Find All causes SqlDbx to hang
• Fixed incorrect catalog /schema display for ODBC Connections
• Fixed Intellisense missing some keywords and object names
• Fixed SQL History not saved / restored correctly.
• Small changes and improvements in different areas

Version 3.32 (23 Aug, 09)

• Added ability to select multiple objects in Object pane using SHIFT key.
• Added ability to select multiple items in Intellisense popup window.
• Added option to specify order of table columns in Intellisense popup window
• Added option to enable number of returned rows by default
• Added option to modify query results directly in Result Grid
• Added ability to modify table data for tables with no unique constraints
• Added new option to float and dock Object View, Edit and Result tabs
• New Editor feature. Go to Line (Ctrl+G) and Mark all occurrences of a word (Ctrl+M)
• New Editor feature. Automatically highlight matching parenthesis
• New Editor feature. Automatically highlight matching BEGIN/END IF/END IF, CASE/END, ... SQL blocks
• Improved generate SELECT/INSERT/UPDATE statement
• Added new option to generate SQL Plus compatible scripts for Oracle
• Changed XML export format. Corrected date format
• Fixed out of memory error when exporting table data to file
• Fixed generation of execute script for Oracle package procedures
• Fixed custom object filter not working
• Fixed Shift key operation in Result Grid
• Fixed exception when copying from Result Grid
• Fixed exception when canceling Oracle queries
• Fixed error when executing Oracle stored procedures with multiple output cursors
• Fixed slow Intelliesense for Oracle and DB2
• Fixed couple system catalog queries for DB2 z/OS

Version 3.31 (14 Jun, 09)

• Custom object filters
• Support for integrated BCP for Sql Server and Sybase
• Added support for password expiration policies for Oracle, Sybase and Microsoft SQL Server
• Added ability to change password
• Added support for Run / Script Execute stored procedures with output parameters
• Scripting improvements for DB2
• Added option to script one object per file
• Changed all DB2 catalog queries for to include WITH UR clause
• Fixed exception when importing large Excel files
• Fixed inconsistent behavior for CHAR columns between ANSI and UNICODE versions
• Fixed Intellisense for Oracle
• Fixed incorrect painting on Vista and Server 2008
• Improved compatibility with some ODBC drivers
• Small changes and improvements in different areas

Version 3.30 (26 Apr, 09)

• Added support for DB2 iSeries/AS400
• Added option to reconnect with different credentials
• Reload list of schemas / databases on reconnect
• Fixed import from Excel ignoring values for some fields
• Fixed issue with Speed Typing settings not being saved correctly
• Server explorer enhancements
• Fixed couple scripting errors for DB2 z/OS
• Improved handling of script variables
• Small changes and improvements in multiple areas

Version 3.29 (01 Mar, 09)

• Added Microsoft and Sybase user types to Intellisense
• Added "Insert New Data Row" option for tables
• Added option to connect to Sybase IQ / Anywhere through Open Client or ODBC
• Added shortcut keys to Show/Hide Results (F11) and Show/Hide Objects (Ctrl+F11)
• Added option to output informational and error messages into Result Grid
• Fixed access violation when opening workspace referencing non existent files
• Fixed access violation for Oracle when entering SQL Plus commands
• Fixed error displaying functions in Server Explorer for Sybase ASE 15.x
• Fixed IDENTITY and COLLATION clause scripting for Microsoft SQL Server
• Fixed Excel export for some locales
• Fixed issue with Favorites not being saved in correct location
• Objects with names containing "." characters were not handled correctly
• ESC key was not closing some dialogs
• Visual data compare was not correctly ignoring trailing right whitespaces
• Improved usability and couple small improvements in different areas

Version 3.28 (06 Feb, 09)

• Added support for Sybase SQL Anywhere and Sybase IQ
• Added new feature: Quick filter in object pane
• Added parameterized queries and substitution variables
• Added ability to define completion keys for Intellisense
• Added two new Excel export options: text, as displayed
• Added "Edit Mode" for procedures / functions / packages
• Added option to force "." as decimal separator
• Fixed Intellisense not showing other Databases / Schemas
• Fixed issue with Replace dialog hanging
• Fixed scripting of user defined types for Sql Server and Sybase
• Fixed incorrect number display for some locales
• Intellisense enhancements
• Scripting improvements
• Usability improvements

Version 3.27 (07 Dec, 08)

• Added SQL formatter / Beautifier (Professional version only)
• Added supports for proportional and Asian fonts. Better IME support
• Added ability to retrieve parent / child rows from Result Grid
• Intellisense improvements
• Improved SQL templates support
• Improved compatibility with some ODBC drivers. Added batch separator (;) for ODBC sources
• Oracle RAW and LONG RAW columns were not displayed correctly
• Fixed speed typing not working correctly
• Fixed error when changing server types in login dialog
• Fixed issue with maximized window covering task bar
• Fixed issue with not being able to edit data in Sybase tables

Version 3.26 (05 Oct, 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
• Fixed Intellisense windows not positioned correctly on multi monitor systems
• Added extended stored procedures to Intellisense (Sybase, Microsoft Sql Server)
• 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