FlySpeed SQL Query

Release History

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.

March 07, 2018

FlySpeed SQL Query 3.7.2.2 changelog

  • Support of ACE.OLEDB.16.0 has been added, detection of installed OLE DB providers for MS Access has been improved.
  • Parsing of incorrect/incomplete "IN" expressions in condition cells of the Query Columns List has been improved.
  • Minor HiDPI fixes have been made.
  • Minor bugfixes and improvements have been made.

February 22, 2018

FlySpeed SQL Query 3.7.2.0 changelog

  • MS SQL Server: Encrypted connections are allowed now.
  • MS SQL Server: Multi-column foreign keys loading for SQL Server 2005 and higher has been fixed.
  • MySQL: Support of STDDEV function has been fixed.
  • MS Access: Error on registering a new connection for the password-protected database has been fixed.
  • Pervasive: Some SQL query parsing fixes have been made.

January 26, 2018

FlySpeed SQL Query 3.7.1.2 changelog

  • The ability to load stored procedures from ODBC driver has been added. The new option is available in the Connection Properties dialog on the Advanced tab. Use it only for those database servers which allow using stored procedures in the FROM clause of SELEŠ”T statement.
  • The bug with the appliance of filter conditions to wrong data column has been fixed.
  • Index numbers in ORDER BY are converted to corresponding expressions now.
  • PostgreSQL parser has been optimized.
  • DB2: Parsing of FOR UPDATE, FOR READ ONLY, ISOLATION and OPTIMIZE FOR in an arbitrary order has been fixed.
  • Oracle, MySQL, MS SQL Server: Several SQL parsing fixes have been made.

January 19, 2018

FlySpeed SQL Query 3.7.1.1 changelog

  • The Tab key navigation by grid columns in the Data View with Form View opened has been fixed.
  • Other minor improvements and bug fixes have been made.