FlySpeed SQL Query

Release History

May 02, 2019

FlySpeed SQL Query 3.7.6.0 changelog

Dutch localization has been added. Thank you, Ronald Konijnenburg!
It is now possible to edit advanced connection properties while creating a new connection.
The advanced database connection properties are separated from the advanced connection program settings in the Connection Properties dialog.
Visual Query Builder: The Query Structure Tree is improved. Subqueries are displayed in the FROM clause of the parent subquery, named subqueries in CTE are displayed correctly. Right-click on tree nodes displays a context menu to perform various actions. The F2 shortcut lets rename subqueries and edit datasource aliases.
The indication of partial SQL query text mode is improved.
Export to CSV has been speeded up.
Several minor bugs have been fixed.

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

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.