dbForge Query Builder for MySQL 2.5.20 - Changelog

What's new in dbForge Query Builder for MySQL 2.5.20:

May 23rd, 2012

· Problem with 'Execute Current Statement' command when the caret is placed after ';' is fixed
· Error report with a table in the Query Builder is fixed
· Problem with HTTP-tunneling is fixed
· Problem with unexpected focused row in the Data Editor is fixed

What's new in dbForge Query Builder for MySQL 2.5.13:

January 13th, 2012

· InvalidCastException on paste data into the Data editor is fixed
· ArgumentOutOfRangeException on searching in Data Editor is fixed
· Bad performance on server side sorting in Data Editor is fixed
· NullReferenceException on switching to the Data document view in the SQL document is fixed
· ArgumentException on editing of several records in Data Editor is fixed
· The problem with windows layout on x64 operating systems is fixed
· ObjectDisposedException on executing a script in a SQL document is fixed
· UriFormatException on saving an SQL file on a mapped network drive is fixed
· NullReferenceException on showing data in Data Editor is fixed
· InvalidCastException on pasting LONGBLOB data in Data Editor is fixed
· InvalidOperationException on deleting a record in Data Editor is fixed
· The problem with changing database for a document is fixed
· The problem with showing the Product Update dialog behind of the main form is fixed
· The problem with connecting to MySQL server using SSL tunnel is fixed
· OutOfMemoryException on changing a page in Data Editor is fixed
· The wrong behaviour of the Continue button in the error message appeared during script execution is fixed
· NullReferenceException on pressing the Enter key in Data Editor after inserting a new record is fixed
· The problem with server-side sorting and filtering in Data Editor is fixed
· The problem with a table locked by a server in Data Editor is resolved
· NullReferenceException on editing data in Data Editor is fixed
· NullReferenceException on opening a SQL file by drag'n'drop operation is fixed
· ArgumentException on editing data in Data Editor is fixed
· Incorrect editing of dates in Data Editor is fixed
· NullReferenceException on parsing text in SQL document is fixed
· DBConcurrencyException on updating records in Data Editor is fixed
· Problem with restoring closed tool windows is fixed
· FormatException on showing data after executing a query is fixed
· A problem with showing the Product update dialog box is fixed
· Few problems with showing the foreign key lookup editor in Data Editor are fixed
· Inability of editing data on MySQL 4.1.22 is fixed
· Incorrect behaviour with changing color of punctuation in code editor is fixed
· Incorrect determination of boundaries for the current statement on executing a query in a SQL document is fixed
· NullReferenceException on filtering data in Data Editor is fixed
· ArgumentOutOfRangeException on switching from the Text view to the Design view in a SQL document is fixed
· Refresh command is added for the Query Builder document to refresh objects on the diagram
· Buttons on the Diagram and Layout toolbars are enabled now
· NullReferenceException on designing a query in Query Builder is fixed
· NullReferenceException on generating text with the last_insert_id function in Query Builder is fixed
· Incorrect renaming of alias on wrapping query to subquery in Query Builder is fixed
· NullReferenceException on wrapping a query to a subquery in Query Builder is fixed
· NullReferenceException on refreshing connection with an opened SQL document is fixed
· ArgumentOutOfRangeException on wrapping a query to a subquery in Query Builder is fixed

What's new in dbForge Query Builder for MySQL 2.5.11:

June 30th, 2011

· NullReferenceException on refreshing data in Data Editor is fixed
· ArgumentOutOfRangeException on loading a SQL file is fixed
· NullReferenceException on fetching data after designing a query is fixed
· Encoding utf8mb4 is now supported
· The Cancel button is now the default one in dialog about uncommited changes in Data Editor
· Annoying notifications in Data Editor are fixed
· Problem with exporting decimal data is fixed
· NullReferenceException on adding/removing select list items in table wrapped to subquery is fixed

What's new in dbForge Query Builder for MySQL 2.5.9:

May 24th, 2011

· ObjectDisposedException on working with autohidden tool windows is fixed
· IndexOutOfRangeException on minimizing and restoring the appilication is fixed
· Lost connection on executing SLEEP function in SELECT statements is fixed
· Application hanging on working with unresponsable server is fixed
· ExternalException on operating clilbpoard operation in LOB Editor is fixed
· Incorrect object describing with ANSI server mode is fixed
· NullReferenceException on showing data in Data Editor is fixed
· The problem with bad handshake on connecting to a server is fixed
· Application hanging on openning a big SQL file with enormous count of JOIN clauses is fixed
· Incorrect detection of default table engine on some MySQL server versions is fixed
· Extra spaces on formatting SQL statements are fixed
· Problems with formatting CASE clauses are fixed
· Automatic diagram layout on its openning is fixed
· FormatException on exporting data to CSV with custom DATE delimiters is fixed
· The problem with exporting data from DECIMAL columns is fixed
· The problem with showing Code Completion window for SUM() function is fixed
· NotImplementedException on refreshing triggers collection in Database Explorer is fixed
· The problem with connecting to MySQL server through SSL tunnel is fixed
· The problem with connecting to embedded MySQL server is fixed

What's new in dbForge Query Builder for MySQL 2.5.8:

May 17th, 2011

Enhanced Data Editor:
· Newly added features and a few totally redesigned ones provide even more freedom when working with data.
· Foreign Key lookup editor added
· Server-side sorting and filtering implemented to avoid retrieving all data from the table and enhance work in Paginal Mode
· Few indications added to inform user about Data Editor's state
· Editing of tables in join statements is enabled now
· Option for numbering records added
· Copy data with header functionality added

Data Export improvements:
· Ability to export data from several tables at once added
· Support for MySQL server 5.5
· Our product is fully compatible with MySQL server version 5.5
· New features were added and obsolete clauses removed in the Syntax check functionality
· New encodings were added to the encoding list in the Connection Properties dialog
· New state-of-the-art skins
· Four new UI skins added to improve the application appearance.

Other improvements:
· Ability to view internal SQL queries that are sent to the server with parameter's values added
· A few UI improvements in Database Explorer

What's new in dbForge Query Builder for MySQL 2.00.5:

May 17th, 2011

New Features:
Meet a stronger Query Builder tailored for creating complex conditions with several clicks. The new power is based on the following:
· Optimized usablility of the Selection tab in the expression editor
· New Wrap to Subquery option to wrap tables into a subquery
· Visual addition of subqueries to any part of the main query
· Optimized navigation in the editor, particularly between subqueries
· Capability to edit view location in the query document
· Joins show connection direction; better described connection properties
· New skin for objects on the diagram
· New SQL document view layout - now you can see query text and retrieved data at the same time
· New tool for database developers - Query Profiler
· dbForge Query Builder offers results of internal MySQL tools like SHOW PROFILE and EXPLAIN in a convenient and clear GUI. Besides you get STATUS variables for the required query automatically calculated.

User reported bug fixes:
· T13265 Transport channel is closed
· T13766,T15231 ArgumentNullException at System.Windows.Forms.DataObject.SetText on working with Data Editor
· T13003 The record pointer moves out of the actual edited record when Ctrl+0 was pressed (fill field with NULL)
· CR51956 Incorrect diplaying datetime values in Data Editor
· T14852 Incorrect display of application toolbars on some operating systems
· T16250 Slow "Views" node opening in the Database Explorer
· T15989 NullReferenceException on retrieving data from the Database Explorer
· CR53449 Query Profiler must show date of profiling result in local format
· CR53501 InvalidOperationException on executing script in SQL document
· CR53593 NullReferenceException after clearing all in the Where editor in Query Builder
· CR53644 NullReferenceException on getting new results in Query Profiler if the document was opened with the loaded database project
· CR53646 Why the Refresh button is disabled after reopen SQL document?
· T20888 NullReferenceException on refreshing data in Data Editor
· CR53720 Do not save opened document views in SQL document
· T21284 Display System.Byte[] instead of default values of table columns on MySQL 4.1.x
· T10942 Add option to ignore query cache on query profiling
· CR53767 Problems with query profiling on MySQL 4.1.x

What's new in dbForge Query Builder for MySQL 1.50.6:

September 8th, 2010

Automatic Connection Recovery:
· If a database connection is broken, dbForge Query Builder for MySQL implicitly recovers it without any error generation.

Improved Data Editor:
· Up to 40 improvements were implemented to create quicker, easier, and more delighted ways for data management. The Data Editor spares tens of mouse clicks a day for you.

Automatic Product Update:
· dbForge Query Builder for MySQL automatically notifies you about any available updates and offers a flexible update process with Product Update Manager. This is a simple and effective way to deliver the new functionality and let you get the maximum of product usage.

What's new in dbForge Query Builder for MySQL 1.10.355:

September 9th, 2009

· HTTP tunneling support added
· SSL and SSH connections support added
· More flexible setting of connection character set is implemented
· NullReferenceException on switching between Text and Design views fixed (T5001)
· NullReferenceException on closing SQL document after work with query builder was fixed (T4712)
· Problems with editing statements in the Query Builder were fixed (T4013)
· Correlated subqueries supported
· Execute Script Wizard added to execute large SQL scripts
· Database connectivity was optimized. Better performance while opening connections, doing data export.
· Performance on large databases has been improved
· Retrieving data from tables has become more faster and convenient
· Problem with regional value of decimal separator during data copy from Data Editor was fixed (T4656)

What's new in dbForge Query Builder for MySQL 1.0.227:

June 12th, 2009

· Problem with retrieving data from Database Explorer was fixed

What's new in dbForge Query Builder for MySQL 1.0.225:

June 12th, 2009

· 'Cannot access a disposed object' error is fixed while working with windows
· NullReferenceException error is fixed while closing the document
· NullReferenceException error is fixed while getting data in Data Editor and scrolling simultaneously
· Unicode data output in LOB editor is fixed
· Problem with changing connection string was fixed