FlySpeed SQL Query

Release History

March 21, 2019

FlySpeed SQL Query 3.7.5.5 changelog

  • Field size and precision are displayed in the Database Explorer tree now.
  • SQL formatting fixes and improvements have been made.
  • The bug with the impossibility to type parentheses has been fixed.
  • The bug with switching to the newly added derived table has been fixed.
  • The bug with not saving the data view settings while working in the Portable mode or in the AppData folder has been fixed.
  • The bug with double scaling of some texts in the SQL Filter builder and the Query Parameters form has been fixed.
  • The bug with the processing of the Unicode NO-BREAK SPACE symbol has been fixed.
  • Pervasive: The list of built-in functions has been updated.

February 26, 2019

FlySpeed SQL Query 3.7.5.4 changelog

  • Predefined SQL formatting schemes have been improved, two new schemes were added.
  • MS Excel: The bug with prompting for a file for each new query window has been fixed.
  • Localization fixes have been made, Italian translation has been updated. (thank you, Fabio Santacaterina)

February 07, 2019

FlySpeed SQL Query 3.7.5.3 changelog

  • MS Excel: The new property "Prompt for a file to open upon connection" allows using a single connection to work with different Excel files.
  • PostgreSQL: The new "Charset" property has been added to the Advanced properties.
  • NexusDB: The list of built-in functions is updated.
  • Visual Query Builder: Turning the query into an inconsistent state by unchecking the global Grouping checkbox has been fixed.
  • Direct execution (Ctrl+F5) for ODBC datasources has been improved.
  • The bug with not applying MS Excel data formats on data export is fixed.
  • The German localization for SQL Filter Builder control has been corrected.

December 21, 2018

FlySpeed SQL Query 3.7.5.2 changelog

  • We wish you and your family Happy Holidays and a Successful New Year! May your cherished dreams and most ambitious plans come true next year!!!
  • The new advanced option for ODBC connections lets deny metadata extraction by means of ODBC driver to overcome specific bugs in the driver causing connection malfunction. It is helpful for some versions of Progress ODBC driver to work with fields containing underscore ("_") symbols. However, this turns off the extraction of primary keys metadata which cannot be retrieved in any other way.

December 13, 2018

FlySpeed SQL Query 3.7.5.1 changelog

  • Database Explorer filter control usability is improved.
  • MS Excel connectivity is fixed.
  • PostgreSQL: Slow parsing of queries with INTERVAL and AT TIME ZONE clauses is fixed.
  • Other minor fixes are made.

November 15, 2018

FlySpeed SQL Query 3.7.5.0 changelog

  • Support for NexusDB is added.
  • Data export has been speeded-up.
  • Direct SQL query execution is improved: parameters pre-processing is turned off.
  • MySQL: The algorithm for choosing the table whose columns are editable in the query result has been corrected.
  • SQL text auto-completion has been improved.
  • Object filter in the Database Explorer is fixed.
  • Double-click functionality in the Database Explorer is restored.
  • The "SQL text before report" option is fixed.

October 30, 2018

FlySpeed SQL Query 3.7.4.1 changelog

  • Code completion has been improved.
  • SAP Hana SQL syntax has been added.
  • Polish translation is updated.
  • The ability to import and export all program settings is added.
  • The movement of settings between locations has been improved.
  • Connection settings are now backed up on each change. Up to 5 backups are stored.
  • Notes are displayed in tooltips for queries in the Database Explorer.
  • Actions to fire totals calculation have been added to the column header's context menu.
  • MySQL: Support for Common Table Expression (WITH clause) has been added.
  • A problem with exporting data from MS SQL Server using Native SQL Client has been hopefully fixed.
  • Re-formatting SQL text doesn't try to connect to a database now.
  • Minor improvements for the data export process have been made.
  • Loading of queries from the history has been fixed.
  • The bug with settings network path to store queries saved in connections has been fixed.
  • Oracle: Ranking functions support has been updated.
  • PostgreSQL: Minor fixes for the EXTRACT function and "AT TIME ZONE" clause have been made.
  • Pervasive: Parsing of date/time builtin functions has been fixed.
  • Other minor bugfixes and improvements have been made.

October 26, 2018

FlySpeed SQL Query 3.7.4.0 changelog

  • Minor bugfixes and improvements have been made.

May 24, 2018

FlySpeed SQL Query 3.7.3.1 changelog

  • Progress DB: Fetching of primary keys has been fixed.
  • Previewing of sub-queries using sub-queries from CTE has been fixed.
  • Data browsing offset doesn't preserved between work sessions now.
  • Incorrect error message after execution of non-SELECT statements is hidden now.
  • Visual Query Builder: The bug with loading complex conditions as join expressions has been fixed.
  • Visual Query Builder: The bug with drawing of union nav.bar when the query contains brackets in set operations has been fixed.
  • Minor bug fixes have been made.

April 25, 2018

FlySpeed SQL Query 3.7.3.0 changelog

  • Support for Pervasive PSQL has been added.
  • GUID formatting options have been added.
  • The new option to hide checkboxes for boolean columns in the data grid has been made.
  • The Ctrl+S shortcut saves new queries to connection rather than to a file.
  • Now it's possible to create SQLite database if one doesn't exist.
  • The information about primary keys now retrieved from ODBC datasources correctly.
  • Localization strings have been updated.
  • The sub-query preview now displays data for sub-queries using CTE correctly.
  • The bug with clearing the Undo buffer after executing the query has been fixed.
  • The Close button on the News form has been fixed.
  • The bug with sorting connections in the 64-bit version has been fixed.