FlySpeed SQL Query

Release History

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.

January 16, 2018

FlySpeed SQL Query 3.7.1.0 changelog

  • Form View redesign has been finalized. Header is stuck to the top of the view on scrolling the content down.
  • It is possible now to export data right from the Database Explorer or from the Query Builder window (in the drop-down menu of the Execute command)
  • Data Export is performed now in a separate thread.
  • Ctrl+A, Ctrl+C shortcuts are working now in the Data Grid.
  • Subscription prolongation procedure has been fixed.
  • Several bugs have been fixed.

January 05, 2018

FlySpeed SQL Query 3.7.0.5 changelog

  • Form view columns header now allows reordering columns by drag'n'drop.
  • The unneeded prompt to save connection settings in the Mixed mode after upgrading to the version 3.7 has been eliminated.
  • Other minor fixes have been made.

December 27, 2017

FlySpeed SQL Query 3.7.0.3 changelog

  • It is now possible to retrieve metadata from several catalogs (databases) using ODBC connection type with Generic ANSI SQL syntaxes.

December 26, 2017

FlySpeed SQL Query 3.7.0.2 changelog

  • Minor improvements in the Form View and software activation dialogs have been made.

December 22, 2017

FlySpeed SQL Query 3.7.0.1 changelog

  • Minor bug fixes and improvements have been made.

December 21, 2017

FlySpeed SQL Query 3.7.0.0 changelog

Sorry, but it's not possible to use the auto-update to upgrade to the new version, as our web site has moved to the HTTPS which is not supported by earlier versions. Please download the new version from the website.

  • The 64-bit version is available now.
  • Data view has been redesigned: Form view has been moved from the tab to a sidebar.
  • Print Preview is now shown in a separate window.
  • BLOB fields viewer is now part of the Form view functionality.
  • Form view has been re-made for better performance and usability
  • New shortcuts are available in the Data view:
    • Ctrl+E - Open the Data Export dialog.
    • Ctrl+P - Open the Print Preview window.
    • Ctrl+D - Open and move focus to the Form view.
  • Comments above the query text are preserved now. Each manual edit of the query text is saved to the History now.
  • Notes can be added to a query on the SQL Text tab.
  • Username and password for Generic OLE DB connections can be defined on the form, not only in the connection string.
  • Edit cancellation prompt is now shown only on pressing the Esc button. It can be turned off in the Program Settings.
  • The "Show in Explorer" item has been added to queries and query folders popup menu.
  • MySQL: JSON data type support has been made.
  • Auto-update and news forms have been redesigned.
  • License activation and subscription prolongation have been made easier.
  • Other minor bug fixes have been made.

You may be interested to read our answer on Quora to the question "What are some good visual SQL query builders?" Please upvote it if you like.