FlySpeed SQL Query

Release History

April 11, 2022

FlySpeed SQL Query 4.0.8.1 changelog

  • Dear users, due to a terrible mistake, an extra file was copied by 4.0.8 version installer to the program installation directory that may lead to the loss or incorrect load of connections data. We are sorry for the inconvenience it may cause you.
  • ATTENTIION! FOR USERS OF THE PORTABLE VERSION: The tool makes backups of connection settings to the "AppData/Local/ActiveDBSoft/FlySpeed SQL Query/.backup" folder in your User profile directory on a PC you changed connection settings last time. Take the one of "connections_backup.X" files that was saved before installing the 4.0.8.0 version (released on April, 8), rename it to "FlySpeed SQL Query.ini" file and place to your program executable folder. Unfortunately, backups are made before applying a change to connection settings, so your last change to settings is lost. :(

April 08, 2022

FlySpeed SQL Query 4.0.8.0 changelog

  • Filter Builder: the bug with defining a list of values is fixed.
  • Filter Builder: We made editing values in the list easier. Enter moves focus to the next item in the list. Alt+Home/End moves focus to the first/last item.
  • SQL Text Editor: Selecting items with mouse is fixed. Selecting an item by mouse now replaces the right part of the identifier.
  • Parameters editor and Filter Builder: The bug with changing minutes along with changing month is fixed. Moving the caret from one date part to another is made automatically now.
  • The bug with crashing on displaying news under Wine is fixed.

April 01, 2022

FlySpeed SQL Query 4.0.7.0 changelog

  • The bug with multiple rows dragging in the query columns grid is fixed.
  • Now, when you update the application, a warning is shown if the current subscription is not applicable to the new version.
  • Added a submenu for the main menu item Options - "Database explorer" to avoid accidentally hiding it.
  • Oracle: Support for missing built-in functions is made.
  • High CPU usage on the Query Builder tab is eliminated.
  • The bug with ODBC connection in 64-bit version is fixed.
  • Other minor improvements and bug fixes are made.

March 25, 2022

FlySpeed SQL Query 4.0.6.0 changelog

  • The query history is fixed.
  • Fields were incorrectly marked as "not null" and vice versa for some servers.
  • The bug with re-running a query with parameters is fixed.
  • Null values for boolean fields aren't displayed as empty check boxes now.
  • The bug with holding down the F5 key on the Query Builder tab is fixed.
  • The "Start "JOIN" keywords from new lines" SQL text formatting option now works correctly in all the cases.
  • The Alt+[Arrow Up/Down] shortcut now lets switch the current SQL statement in the script.
  • Oracle SQL syntax fixes are made.

March 16, 2022

FlySpeed SQL Query 4.0.5.0 changelog

  • The bug with freezing on loading large databases is fixed.
  • Other minor visual fixes and improvements are made.
  • Polish localization is updated.

March 09, 2022

FlySpeed SQL Query 4.0.4.0 changelog

  • The DB Explorer tree font can be manually scaled with Ctrl+[Mouse wheel scroll].
  • Choosing the default location of the Query Results data view made easier with the new Execute drop-down control on the SQL Text tab toolbar.
  • The new SQL Text tab toolbar switch instructs to move caret to the next statement AND create new Query Result tabs below the text. This mode lets execute SQL statements in the script one by one with just one toolbar command or shortcut (F5).
  • The default query execution options can be set globally in the Query Window tab of the Options - "Settings..." dialog.
  • Minor bugs are fixed.

February 22, 2022

FlySpeed SQL Query 4.0.3.0 changelog

  • Flickering on switching between query windows is eliminated.

February 17, 2022

FlySpeed SQL Query 4.0.2.0 changelog

  • SQL Text Editor shortcuts are changed:
    F5 runs the current query in the current window,
    Ctrl+F5 runs the selected text in the current window,
    F9 runs the current query in a separate window,
    Shift+F5 runs the current query in a new query results tab, (only in the SQL Text tab)
    Ctrl+Shift+F5 runs the selected text in a new query results tab. (only in the SQL Text tab)
  • Field types and descriptions are now shown in the hint on hovering a node in the tree.
  • The new global option determines the display of field type in captions. Check the Options - Settings menu, Common Options - Database Explorer - "Show field type after name" box.
  • SAP Hana: Support for analytic expressions is added.
  • MS SQL Server: The TIME built-in type parsing is fixed.
  • Pervasive DB: The ambiguity in the IF built-in function parsing is eliminated, so parsing is speeded up.
  • Pervasive DB: Parsing of the DatePart keywords as identifiers are fixed.
  • Font scaling is improved.

February 01, 2022

FlySpeed SQL Query 4.0.1.1 changelog

  • The bug with parsing arbitrary query text ("Unexpected token EOF at line 1 pos 1") is fixed.

January 30, 2022

FlySpeed SQL Query 4.0.1.0 changelog

  • Data Import: Source data conversion to Boolean and DateTime is made smarter. The highlighting of invalid values to convert to the specified type is made.
  • Data Import: Column separator autodetection is made.
  • Data Import: The bug on importing into Date field is fixed.
  • Pervasive and SAP Hana SQL syntax fixes are made.