Release History

FlySpeed SQL Query History

October 11, 2017

+ Now it's possible to enter parameters of stored procedure (table-valued
  function in MS SQL) after it's got added to the query in the Visual Query
  Builder using the Datasource Properties dialog.
+ The new option "Deny data export optimizations" has been added to the
  Advanced tab of Connection Properties dialog. Turn it on in case you have
  errors during the data export like "Invalid cursor position", etc.
- Other minor improvements and bug fixes have been made.

September 28, 2017

+ SQL Formatting: new options to format sub-queries and conditional
  expressions (IF and CASE) have been added.
- Plenty of minor bug fixes and minor improvements have been made.

September 15, 2017

- The bug with resetting MySQL server host to "localhost" has been fixed.
- The bug with not saving server versions for some database servers
  has been fixed.
= SQL formatting options have been redesigned.
+ Dynamically indented SQL formatting has been improved.
- Minor bug fixes and ipmpovements have been fixed.

September 13, 2017

+ Italian localization has been added. Thanks to Fabio Santacaterina for
  his hard work.
+ DB2: The new property "Retrieve metadata from ODBC driver" has been added.
  It is set by default to True as this way is faster and takes DSN settings
  into account, but in this mode descriptions for tables and fields cannot
  be retrieved.
+ SQL formatting option to place comma on the next line before the next item
  in the list (SELECT, ORDER BY, GROUP BY) has been added.
- PostgreSQL: The bug with not retrieving foreign keys has been fixed.
- Localization updates, forms beautifying, HiDPI fixes and other bug fixes
  have been made.

September 06, 2017

+ Parameterized queries can be previewed now. 
+ You can change parameter values via the special bar above the Data grid now.
+ DB2: Descriptions for tables are extracted now.
- DB2: The SQL_ERROR problem on trying to connect to AS/400 database version
  lower than 7 has been fixed.
- PostgreSQL: Incorrect displaying of UUID fields has been fixed.
= Localizations are updated.

September 05, 2017

+ The Connection Parameters form has been redesigned.
+ Now it's possible to display descriptions for database objects.
  Turn on the "Show metadata object descriptions" property on the Database
  Explorer tab in the General Program Settings dialog.
- Text Editor: Selection movement on indent/unindent commands has been
- Text Editor: The bug in Replace command in selection has been fixed.
= Localization files have been updated, missing strings have been added.
- Other minor improvements and bug fixes have been made.

August 17, 2017

+ The new "Write ODBC trace to connection log" connection option has been
  added to the Advanced tab for ODBC and DB2 connection types.
- More missing strings have been added to the Default.lng file

August 15, 2017

= Memory and speed optimizations for Data Export process have been made.
+ German localization has been added.
- Localization fixes have been made.
+ Icons are scaled properly now on hi-resolution monitors.
= Execution of non-SELECT statements or SELECT statements prefixed by 
  DECLARE or SET statements has been simplified: no need to hold down 
  the Ctrl key.

July 11, 2017

- The bug in the Mixed mode which resulted in a try to save connection 
  settings after the database password prompt has been fixed.
- The bug with saving size and position of the main form and some other
  user settings has been fixed.

July 07, 2017

- Minor bugs have been fixed.