FlySpeed SQL Query

Release History

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.

March 29, 2018

FlySpeed SQL Query 3.7.2.4 changelog

  • Previously used values for unnamed parameters are restored correctly now.
  • Minor bugfixes have been made.

March 23, 2018

FlySpeed SQL Query 3.7.2.3 changelog

  • The bug which caused unhandled exception on editing data in MySQL in datasets with columns which require quotation has been fixed.
  • The bug which prevented reading the registration information from the ini file in the program executable folder has been fixed.