FlySpeed SQL Query

Release History

August 02, 2021

FlySpeed SQL Query 3.8.5.0 changelog

  • The ability to select visible databases for connection is back. Metadata filter obeys this selection so it takes less time to load metadata.
  • The ability to select visible schema for Oracle and other servers that support multiple schemas but don't support databases is added.
  • Filter on the Result Data tab wasn't applied to Data Export if aliases were used in the query. Fixed now.
  • The subscription update process has been made easier.
  • It is possible now to select a single statement in the script on the SQL text tab with Ctrl + [Left button click].
  • Denodo Virtual DataPort metadata loading fixes are made.

July 01, 2021

FlySpeed SQL Query 3.8.4.3 changelog

  • The recently introduced bug with exporting data has been fixed.
  • Fixes for the Metadata Filter Editor are made.
  • The bug with copying table data from the grid to the clipboard using the Ctrl+C shortcut is fixed.
  • Animation on executing the sub-query data preview query is added.
  • Other minor fixes are made.

June 25, 2021

FlySpeed SQL Query 3.8.4.1 changelog

  • PostgreSQL: Database objects weren't displayed for new connections, fixed now.
  • SQL Text Editor: The bug with not selecting the whole word on double-click is fixed.
  • Denodo Virtual DataPort: Metadata loading has been fixed.
  • Metadata Filter Editor doesn't hang anymore.
  • Unnecessary prompts on copying large chunks of data to clipboard aren't displayed now.
  • Form View: A button to display more fields is added to the bottom.
  • Objects are added unsorted to the DB Explorer tree.
  • The windows toolbar is draggable again.
  • The bug with not remembering the expanded state of connection folders is finally fixed now.
  • Several unexpected errors are eliminated.

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.