FlySpeed SQL Query

Release History

June 09, 2021

FlySpeed SQL Query 3.8.3.0 changelog

  • The Oracle connection properties form has been redesigned. Now you can switch between different ORACLE_HOME settings and pick the right TNS name from the list. The ability to specify port and service name in separate controls has been made.
  • The New Connection Wizard has been redesigned. Now you can switch between OLE DB, ODBC, and direct connection to the database server. The database selection step has been simplified.
  • The expanded/collapsed state of connection folders is now saved between work sessions.
  • The way the date and time added to the export file name has been improved.
  • The initial support for Denodo Virtual DataPort has been added.
  • Teradata: A fallback to non-X system views if X-views are not available has been made.
  • Metadata filter bugs are fixed.

May 13, 2021

FlySpeed SQL Query 3.8.2.0 changelog

  • The ability to export and import queries saved in connections has been made. It is now a complete set of settings to make backups and move settings to another PC. Use the Options - Export/Import Settings menu for this.
  • The new database object filter made it easier. You can open the dialog to define filters on the Settings tab of the Connection Properties dialog.
  • Data Export: MRU list for the filename is added.
  • Data Export: A new option allows for adding the current date and time to the filename automatically.
  • It is now possible to filter the lookup data in the filter builder on the Data View tab.
  • One can execute the selected fragment from the query text in a new window. The appropriate toolbar button changes its caption when text is selected in the editor.
  • Visual Query Builder: Now it's possible to save the layout of the Visual Query Builder tab layout, including panes visibility and ratio, the width of columns in the Query Columns Grid. Use the "Save the default visual query builder layout" toolbar button on the Query Builder tab.
  • One can close windows by right-clicking on the windows bar buttons.
  • Data View: Captions of detail data tabs are made shorter.
  • The new global option to display "null" text for NULL values is added to the Grid View tab.
  • It's now possible to hide the Preview tab below the Visual Query Builder via the "Show data preview on the Query Builder tab" global option on the Query Window tab.
  • MySQL and other servers where applicable: The new option to use checkboxes for displaying and editing fields of TINYINT type is added to the Advanced tab of the Connection Properties dialog.
  • DB2: Support for the EXCEPTION JOIN is added.
  • DB2 for AS/400: Connection to old versions is hopefully fixed.
  • Pervasive: Parsing of the IF, DateAdd, DateDiff, and DatePart functions, and the DOUBLE built-in type is fixed.

March 05, 2021

FlySpeed SQL Query 3.8.1.1 changelog

  • Support for HiRes scaling modes has been improved.
  • DB Explorer: Inline renaming of connections is possible now with the F2 shortcut.
  • DB Explorer: The position of query/connection drop is indicated more precisely now.
  • Query window: Now it's possible to switch between tabs using the Ctrl+1-5 shortcuts.
  • Other minor bugfixes and UI improvements are made.

February 20, 2021

FlySpeed SQL Query 3.8.1.0 changelog

  • Support for HiRes scaling modes has been improved.
  • Running the tool with command-line switches returns errors to the console instead of showing dialog boxes.
  • The user is prompted to copy the queries stored in connection on copying a connection itself.
  • Other minor bugfixes and UI improvements are made.

February 05, 2021

FlySpeed SQL Query 3.8.0.2 changelog

  • It is now possible to deactivate an installation using the "/unregister" command-line switch.
  • The bug with displaying the MRU list in the Parameter Values form has been fixed.
  • Auto-generation of short object aliases is disabled by default.
  • Slow rendering of data view with many null cells has been fixed.
  • Other minor bugs are fixed.

February 03, 2021

FlySpeed SQL Query 3.8.0.1 changelog

  • French localization has been added.
  • The "Execute in a New Window" command executes only the selected text; if there's no selection, it executes the whole script.
  • The bug with not displaying fields in the DB Explorer tree has been fixed.
  • The bug with not saving date values for persistent parameters has been fixed.
  • The bug with not showing the detail view on creating a new view has been fixed.

January 31, 2021

FlySpeed SQL Query 3.8.0.0 changelog

  • Spanish localization has been added.
  • SQL Text Editor: It is possible now to execute the selected SQL text.
  • It is now possible to pin a parameter name so its value will be applied to same-named parameters in other queries.
  • Visual Query Builder: Short aliases are generated for new objects in the query.
  • Query History: A command to run a query from the history in a separate window is added.
  • Query Statistics: It is possible to select and copy the statistics data.
  • Data view: The new button is added to hide/show the detail pane.
  • Data view: NULLs are explicitly indicated in the grid now.
  • DB Explorer: It is possible now to make a copy of the connection or query.
  • DB Explorer: Matched fragments are highlighted during the search.
  • DB Explorer: Fields order in the tree now obeys the QueryBuilder datasource fields sort order setting.
  • Minor SQL syntax fixes for PostgreSQL, MySQL and other servers are made.

September 26, 2020

FlySpeed SQL Query 3.7.11.3 changelog

  • Users now can create links from UI separately indicating the beginning and end field via the datasource field context menu.
  • Minor syntax fixes for PostgreSQL, MySQL and SAP Hana are made.

June 01, 2020

FlySpeed SQL Query 3.7.11.2 changelog

  • The bug with incorrect encoding when exporting data to CSV is fixed.

May 26, 2020

FlySpeed SQL Query 3.7.11.1 changelog

  • Minor bugs are fixed.