FlySpeed SQL Query

Release History

June 11, 2019

FlySpeed SQL Query 3.7.7.1 changelog

  • SQL Text Editor: Minor fixes have been made.
  • SQL Text Editor: The unhandled exception on selecting all text has been fixed.

June 10, 2019

FlySpeed SQL Query 3.7.7.0 changelog

  • Suggestion list hiding, showing, and operating behavior has been made more intuitive. Feel free to send us your feedback.
  • Suggestions are now sought by substring, first letters, and camel case.
  • Dragging object names from the DB Explorer to the SQL text editor has been improved.
  • The new command "Get Last n Records" has been added to the popup menu for objects in the DB Explorer.
  • MySQL, PostgreSQL: Support for parsing queries with window functions has been made.
  • SQLite: The bug with displaying GUIDs has been fixed.
  • DBF files: The bug on reopening connection has been fixed.
  • The bug with the reopening of incorrect saved queries has been fixed.
  • HiDPI scaling issues have been fixed.

May 03, 2019

FlySpeed SQL Query 3.7.6.1 changelog

  • The bug with not updating the text of saved queries on modifying them in the Visual Query Builder has been fixed. We are terribly sorry for the inconveniences this problem caused you!
  • The "Fetch on demand" option is added to the Advanced Connection properties for all applicable connection types. Although it is set off for new connections, it was implicitly set on for existing connections. We recommend you to manually set it off to benefit from the paginated data browsing.

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.