FlySpeed SQL Query

Release History

October 16, 2019

FlySpeed SQL Query 3.7.8.0 changelog

  • SQL Text Editor: The performance of database object suggestion box has been improved.
  • Autoupdating data in detail views is made smoother now.
  • Trying to fix the problem with the main window on top of modal dialogs.
    Please send your feedback.
  • PostgreSQL: Support for DISTINCT ON syntax has been made.
  • Informix: Support for new built-in functions (LEFT, RIGHT) has been added.
  • Informix: Support for derived tables for IDS11+ has been made.
  • Oracle: Support for OFFSET/FETCH for Oracle 12+ has been made.

October 04, 2019

FlySpeed SQL Query 3.7.7.6 changelog

  • Crashes in the SQL Text Editor have been fixed.
  • PostgreSQL: filtration and sorting of case-sensitive objects and fields in the Data View is restored.
  • Problems with Pervasive and Informix database servers have been eliminated.
  • Minor bug fixes and improvements have been made.

July 11, 2019

FlySpeed SQL Query 3.7.7.5 changelog

  • Minor bugfixes are made.

July 09, 2019

FlySpeed SQL Query 3.7.7.4 changelog

  • Oracle: Dot-prefixing of objects with an empty schema has been fixed.

July 06, 2019

FlySpeed SQL Query 3.7.7.3 changelog

  • Query Structure Tree: Sub-queries from WHERE clause and SQL expressions from other parts of the query are shown in the tree now.
  • SQL query modifications are made faster now. Notable on large queries.
  • Overall performance has been improved.
  • SQL Text Editor: Typing of colon-prefixed parameters has been fixed.

July 01, 2019

FlySpeed SQL Query 3.7.7.2 changelog

  • The "Enable Code Autocompletion" option is fixed.
  • Support for AbsoluteDB has been restored.
  • Minor problems with the "Get last xx records" command have been addressed.
  • New server versions are listed now for MySQL, MS SQL Server, and Oracle.
  • Visual Query Builder: The single-line expression editor in the Link Properties Form has been replaced with a memo field.
  • SAP SQL Anywhere: Loading of objects for a non-privileged user has been fixed; modern views are used now for v.17 and higher.
  • SQLite: Union operators list has been fixed.
  • SQLite: Support for GUID fields has been fixed.

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.