Softpedia >Windows >Internet >Servers >Database Utils >FlySpeed SQL Query >  Changelog

FlySpeed SQL Query Changelog

What's new in FlySpeed SQL Query 4.8.5.0

Apr 5, 2024
  • The object fields loading is optimized.
  • Creation of data export tasks for queries in sub-folders is fixed.
  • Idle CPU load is minimized.
  • Firebird: Connection to embedded servers is fixed.
  • Firebird: The ability to create a new database is added.
  • The bug with displaying the number of selected rows for detail data views is fixed.
  • Unhandled crashes while working with data view are eliminated.

New in FlySpeed SQL Query 4.8.4.1 (Mar 12, 2024)

  • The bug with executing a query with unnamed parameters is fixed.
  • The bug with data view filtration and sorting is fixed.
  • The crash on undoing changes with focused visual query builder is eliminated.

New in FlySpeed SQL Query 4.8.4.0 (Mar 7, 2024)

  • French localization is updated
  • Pervasive: metadata loading is fixed.
  • Parameter values form initialization is optimized.
  • Data view: the number of selected rows now displayed in the status bar.
  • Azure: MFA authentication for AAD is enabled.

New in FlySpeed SQL Query 4.8.3.0 (Jan 26, 2024)

  • MySQL: New aggregate functions are added.
  • Snowflake: The bug with some aggregate function names is fixed.
  • Snowflake: Support for POSITION and FLATTEN functions is made.
  • MS SQL Server: Support for WITHIN expression is made.
  • SQL text editor: New SQL Server functions are added to the suggestions list.
  • SQL text editor: Suggestions list tooltips are back.
  • Informix: The fault on opening a query during the metadata load has been addressed.
  • Informix: The "Inexact character conversion during translation" error is handled.
  • Oracle: The fault on retrieving data using the 64-bit ODBC driver has been eliminated.

New in FlySpeed SQL Query 4.8.2.0 (Dec 31, 2023)

  • Data Export to .xslx is speeded up up to 4x.
  • Data Export via OLE DB is optimized in memory use.
  • Data Grid view toolbar customizations are saved between sessions now.
  • MySQL: Parsing of "=false" and "=true" expressions is speeded up.

New in FlySpeed SQL Query 4.8.1.0 (Dec 21, 2023)

  • Data grid: Per-column data format and appearance customization is made.
  • Data grid: Saving of column order between sessions is fixed.
  • Export tasks: Option to overwrite existing files or abort is added.
  • Firebird: Appliance of the client library property is fixed.
  • Oracle: Parsing of expressions with parentheses is optimized.

New in FlySpeed SQL Query 4.8.0.0 (Dec 8, 2023)

  • Data export tasks are here. Now you can save your exports to a task and run it with a single click. Feel free to share your feedback.
  • Oracle: Encoding is always set correctly now despite of the TNSNAMES settings.
  • Several minor issues were fixed.

New in FlySpeed SQL Query 4.7.3.0 (Oct 26, 2023)

  • The bug with copying of selected columns is fixed.
  • Oracle: Support for percentile_cont, percentile_disc functions is added.
  • Denodo: Support for analytic functions is added.
  • Denodo: The crash on displaying numbers with more than 38-digit precision is eliminated.
  • Firebird: The crash on setting the Command Timeout for server v.3 and less is eliminated.
  • Firebird: Server version autodetection is made.

New in FlySpeed SQL Query 4.7.2.0 (Sep 3, 2023)

  • French localization is updated (thanks to Fabrice).
  • UTF8 endoding is used now on opening a file from Explorer.
  • The bug with detecting parameter data type for tables without primary key is fixed.
  • Snowflake: The bug on parsing "Left" function is fixed.
  • PostgreSQL: The compatibility with Redshift is fixed.

New in FlySpeed SQL Query 4.7.1.0 (Aug 17, 2023)

  • The hang on pasting or typing a query and switching to the Query Builder is fixed.

New in FlySpeed SQL Query 4.7.0.0 (Aug 11, 2023)

  • Snowflake SQL syntax support is made.
  • Firebird SQL syntax is updated to v.4.
  • MySQL: support for "is NOT true", "is NOT false" is made.
  • PostgreSQL: Parsing of queries with TIMESTAMP type name is speeded up.
  • SQL Text Editor is optimized for very long strings.
  • Several fixes and minor UI improvements are made.

New in FlySpeed SQL Query 4.6.0.1 (Jul 12, 2023)

  • The crash on closing a query after disconnect is eliminated.
  • MySQL: Support for "IS TRUE" and "IS FALSE" conditions is added.

New in FlySpeed SQL Query 4.6.0.0 (Jun 22, 2023)

  • SQL Text Editor: The ability to collapse subqueries is added.
  • SQL Text Editor: The UI to collapse/expand queries and subqueries on the gutter is redesigned.
  • SQL Text Editor: Autoindenting on empty lines is corrected.
  • Polish localization is updated.
  • Parameter values editor: Pasting values to the numeric editor using the Ctrl+V shortcut is possible now.
  • Parameter values editor: Entering bigint values is possible now.
  • The bug with losing SQL changes on moving out of the Query Builder tab is fixed.
  • The bug with applying incorrect default schema/database on changing connection for a query is fixed.
  • The addition of a saved query as a derived table to the current queyr is fixed.
  • The bug on connecting to Firebird 4 is fixed.
  • High CPU consumption when idle is eliminated.
  • PostgreSQL: Parsing of the AT TIME ZONE operator is fixed.
  • PostgreSQL: Partitioned tables are displayed in the Database Explorer now.
  • MS SQL Server: Parsing of the AT identifier is fixed.
  • SAP Hana: Parsing of the STRING_AGG with ORDER BY clause is fixed.

New in FlySpeed SQL Query 4.5.1.0 (Apr 29, 2023)

  • The new Save All and Close All actions are added.
  • Minor bugs are fixed.

New in FlySpeed SQL Query 4.5.0.4 (Apr 23, 2023)

  • The bug with the inability to export data from unparsable queries is fixed.

New in FlySpeed SQL Query 4.5.0.3 (Apr 19, 2023)

  • The bug on exporting data to SQL script is fixed.

New in FlySpeed SQL Query 4.5.0.2 (Apr 19, 2023)

  • The bug on opening the Data Export form in some cases is fixed.

New in FlySpeed SQL Query 4.5.0.1 (Apr 18, 2023)

  • Exporting data to JSON and SQL script is possible now.
  • SQL Text Editor. Several crashes related to the work with collapsed regions are eliminated.
  • SQL Filter Builder. The bug with decimal numbers when the decimal separator differs from the system is fixed.
  • Data grid. Decimal numbers are no longer displayed as currency.
  • MySQL: The bug with Group_Concat function parsing is fixed.

New in FlySpeed SQL Query 4.4.0.1 (Apr 5, 2023)

  • The crash in SQL text editor has been eliminated.
  • BCD fields are formatted as currency now.

New in FlySpeed SQL Query 4.4.0.0 (Apr 1, 2023)

  • The work with SQL Text Editor is made smoother. Its performance with large SQL scripts is optimized.
  • MS SQL Server: The ability to connect using AAD has been added.
  • New Connection Wizard: The ability to choose visible schema has been added.
  • Form View: The bug on displaying Datetime vaules is fixed.
  • Polish localization is updated.
  • The bug on exporting data to *.xlsx format is fixed.
  • Oracle: Metadata is loaded in the alphabetical order now.
  • Nexus DB: Support for GUID literals and boolean value expressions is made.
  • MS SQL Server: Table hints parsing is improved, the need for alias for table-valued functions is eliminated.
  • IBM DB2: The bug on loading fields for objects for DB2 for AS/400 is fixed.

New in FlySpeed SQL Query 4.3.2.0 (Feb 14, 2023)

  • The new option is added to the default behavior on query double click: "Switch to Query tab".
  • Saving DB connection order after sorting between sessions is fixed.
  • French and Italian localizations are updated (thanks to enthusiasts!)
  • Support for Edge browser to display news is added.
  • Drawing of saved data filters when filter content is collapsed is fixed.
  • Minor SQL parsing issues are addressed.

New in FlySpeed SQL Query 4.3.1.0 (Jan 12, 2023)

  • DB Explorer: A new action has been added to the query context menu: "Switch to the Query Tab". It's active when this query is already open.
  • Data Export: Column visibility is taken into account when exporting data from the grid.
  • Visual Query Builder: The bug with hiding of tooltips is fixed.
  • Several crashes were fixed.

New in FlySpeed SQL Query 4.3.0.2 (Dec 27, 2022)

  • Inconvenient default formatting for numeric and currency fields is reverted.
  • Visual Query Builder: The bug with wrapping datasources into a subquery is fixed.
  • SQL Filter Builder: The crash on moving condition is eliminated.

New in FlySpeed SQL Query 4.3.0.1 (Dec 16, 2022)

  • Importing data from *.xls/xlsx files is possible now.
  • The ability to wrap objects in a query into a sub-query is added.
  • Now you can start data import from the Database Explorer tree context menu.
  • New options are added to setup data copying to the Clipboard.
  • New data formatting options are added to round numeric data in the grid, during data export and import.
  • Some bugs led to incorrect data importing in rare cases are fixed.
  • Data export to HTML and XML now obeys data formatting options.
  • Several crashes are fixed.
  • Oracle: Support for VALIDATE_CONVERSION builtin function is fixed.
  • MS SQL Server: Alias for table-valued functions is reqiured now.

New in FlySpeed SQL Query 4.2.4.0 (Oct 25, 2022)

  • SQL Filter Builder: Now the user can select multiple items with ctrl+mouse click or by selecting a rectangle with mouse. Then, wrap them into a group or move.
  • Now the tool asks for action on pasting complex data from the Clipboard to data grid: to paste data to one cell or import data.
  • Other minor bug fixes and improvements were made.

New in FlySpeed SQL Query 4.2.3.0 (Oct 6, 2022)

  • Data Import: The last line of the imported CSV file was ignored. Fixed now.
  • High CPU load with large amount of data in the Clipboard is eliminated.
  • SQL Text Editor: The "Execute selected text" button was displayed on the gutter even if connection is inactive. Fixed now.
  • Incorrect values might be passed to the parameter values form. Fixed now.
  • Criteria Builder: The lookup grid doesn't show empty and null values.
  • Criteria Builder: Minor bugs are fixed.
  • Several crashes are eliminated.

New in FlySpeed SQL Query 4.2.2.0 (Sep 9, 2022)

  • Data Grid: Now the user can select a rectangular region of data and copy it to the Clipboard.
  • Filter Builder: now you can save your filters and switch beween them or turn it on/off.
  • Filter Builder: The "in list" value editor is improved. Now you can paste the copied data to it. Other minor improvements are made.
  • Denodo virtualization server: The bug with numeric data of high precision is fixed.
  • Other minor fixes and improvements are made.

New in FlySpeed SQL Query 4.2.1.0 (Jul 26, 2022)

  • SQL Text Editor: The bug with scrolling the text area back to the right is fixed.
  • Data Import: When updating data by key, the cells about to be changed are highlighted with the green background in the data mapping preview.
  • Minor bug fixes are made.

New in FlySpeed SQL Query 4.2.0.0 (Jul 14, 2022)

  • Data Import: Now you can update existing data with imported data by key.
  • Filter Builder: Now you can copy and paste the list of values to the “in list” condition.
  • Form View: Resizing of multi-line editors is made smoother.
  • DB Explorer: Filter is now applied as you type. It now searches for connection and folder names.
  • Exporting data to Excel (.xlsx) is speeded up.
  • Loading settings from the .ini file is speeded up. The tool starts faster now in portable mode.
  • Data Import: Importing UTF8-encoded data is fixed.
  • Text editor: Selection on undoing changes is fixed.
  • Export to HTML: HTML format is fixed. (position of the closing “html” tag is corrected)
  • Minor fixes and several crash incidents are made.

New in FlySpeed SQL Query 4.1.3.0 (Jun 17, 2022)

  • SQL Text Editor: Selecting the current SQL statement text is now possible by Ctrl+[left mouse click] on the gutter, but not possible with the same combination in the text area.
  • Data import memory consumption is minimized.
  • Other minor fixes and improvements are made.

New in FlySpeed SQL Query 4.1.2.0 (Jun 10, 2022)

  • The "Open" toolbar button is fixed.
  • Buttons for Comment and Uncomment Lines commands are added to the toolbar. Ctrl+Alt+C, Ctrl+Alt+U shortcuts are added.
  • The unhandled exception on Undo command is eliminated.
  • Polish localization is updated.

New in FlySpeed SQL Query 4.1.1.0 (Jun 9, 2022)

  • Data Import: Setting up data formats for float and currency types, null values is fixed.
  • Data Import: The detection of read-only and nullable columns is improved.
  • One can choose encoding while saving and loading queries to files now.
  • String values copied from the grid are quoted now.
  • Other minor fixes and improvement are made.

New in FlySpeed SQL Query 4.1.0.0 (May 27, 2022)

  • The Data Import wizard has been replaced with a simple Import Options dialog.
  • Data Import: Data type conversion errors can be omitted now. In the case of error, Null value will be written if possible.
  • Data Import: Data type conversion errors are highlighted now in the Data mapping preview grid.
  • Data Import: The data mapping UI is made simpler and more informative.
  • Search and Replace dialog settings are synced across query windows saved between work sessions.
  • Minor bugs are fixed.

New in FlySpeed SQL Query 4.0.10.1 (Apr 29, 2022)

  • Query windows bar is redesigned. A button to close the window is added, width is aligned, connection name is displayed after the query or object name.
  • The bug with not applying metadata filter to schemes is fixed.
  • A button is displayed on the gutter on selecting a piece of text to execute the selected fragment.

New in FlySpeed SQL Query 4.0.9.2 (Apr 23, 2022)

  • The bug on closing a query window having the Result Data tab opened is fixed.

New in FlySpeed SQL Query 4.0.9.1 (Apr 20, 2022)

  • SQL Text Editor: The current statement pointer now follows the cursor in the text. If you prefer to control this pointer manually, uncheck the "Treat the current query as under the cursor" option in the Query Window tab in the Program Options dialog.
  • SQL Text Editor: Buttons to switch the current statement pointer in the text are moved to the new vertical toolbar at the right.
  • SQL Text Editor: The button to re-format the current statement is added to the SQL Text tab toolbar.
  • The issue with updating the number of records in the status bar is fixed.
  • Data Import: The "Captions in the first record" option is switched off when the clipboard contains just one line of text.
  • Program options import and export is improved.
  • We made other minor improvements and bug fixes.

New in FlySpeed SQL Query 4.0.8.1 (Apr 11, 2022)

  • Below is the list of bugfixes and improvements in FlySpeed SQL Query 4.0.8.1.
  • IMPORTANT! 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 incorrect load of connections data. We are sorry for the inconvenience it may cause you. Applying this update will NOT remove this file!
  • YOU SHOULD MANUALLY REMOVE (better rename) an empty (0 bytes) "FlySpeed SQL Query.ini" file from the program installation directory (usually "C:/Program Files/ActiveDBSoft/FlySpeed SQL Query").

New in FlySpeed SQL Query 4.0.8.0 (Apr 8, 2022)

  • 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.

New in FlySpeed SQL Query 4.0.7.0 (Apr 2, 2022)

  • 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.

New in FlySpeed SQL Query 4.0.5.0 (Mar 16, 2022)

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

New in FlySpeed SQL Query 4.0.4.0 (Mar 11, 2022)

  • 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.

New in FlySpeed SQL Query 4.0.3.0 (Feb 24, 2022)

  • Flickering on switching between query windows is eliminated.

New in FlySpeed SQL Query 4.0.2.0 (Feb 17, 2022)

  • 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.

New in FlySpeed SQL Query 4.0.1.1 (Feb 1, 2022)

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

New in FlySpeed SQL Query 4.0.1.0 (Jan 31, 2022)

  • 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 fies are made.

New in FlySpeed SQL Query 4.0.0.3 (Jan 20, 2022)

  • Form View: Null values were displayed incorrectly in the date editor. Fixed now.
  • The tool is now able to check the license upgrade to the Professional version.
  • Grid View: The grid header look is improved.
  • Data Import: You can now specify a constant to fill a field.
  • Minor SQL syntax fixes for SQL Server, Informix and Denodo are made.

New in FlySpeed SQL Query 4.0.0.1 (Dec 23, 2021)

  • Some HiDPI-scaling issues are fixed.
  • The bug on importing data to certain queries is fixed.

New in FlySpeed SQL Query 4.0.0.0 (Dec 23, 2021)

  • The Professional version is out. Using it you can import data into your DB in a few simple steps.

New in FlySpeed SQL Query 3.9.2.8 (Nov 20, 2021)

  • Subquery data preview: Fixes, speeding-up, and displaying of the query execution state are made.
  • Now you can close a query window WITHOUT SAVING the query with Ctrl+[Right mouse click] on the query windows bar button.
  • The program correctly takes the default font size for SQL Text Editor from the general program settings.
  • Other minor improvements and fixes are made.

New in FlySpeed SQL Query 3.9.2.7 (Nov 16, 2021)

  • Crashes when closing the Connection Parameters form and wizard were fixed.
  • Some other cases of crashing are fixed.

New in FlySpeed SQL Query 3.9.2.6 (Nov 14, 2021)

  • The bug with the inability to change font on HiDPI monitors is fixed.
  • Few minor issues are solved.

New in FlySpeed SQL Query 3.9.2.5 (Nov 12, 2021)

  • Font changing and saving in the grid has been improved. Issues on HiDPI monitors are addressed.
  • Keyboard shortcuts Ctrl-0,[minus],[plus] for font changing are added.
  • The ability to reset field settings in the Form View is made. Saving the settings is fixed.
  • The bug with not saving values for parameters with undefined type has been fixed.
  • Visual Query Builder: Unwanted focus switching on hovering the mouse over the objects on Design Pane are eliminated.
  • Polish localization is updated.

New in FlySpeed SQL Query 3.9.2.4 (Nov 4, 2021)

  • Font scaling is implemented in SQL text editors and data grids. Use the "Zoom in/out" toolbar buttons or use the [Ctrl]+[Mouse wheel up/down] shortcut.
  • MySQL: The new setting lets you treat tinyint as integer, not boolean type.

New in FlySpeed SQL Query 3.9.2.3 (Nov 2, 2021)

  • Column aliases are left unquoted if quotation is not needed.
  • SQLite: Setting DateTime filters is fixed.
  • Oracle 8 and eariler: Conditions from the query weren't applied to the result data. Fixed now.
  • Firebird: CTE can be used in subqueries now.

New in FlySpeed SQL Query 3.9.2.2 (Oct 20, 2021)

  • The bug with defining filter for date fields while working with an SQLite database is fixed.

New in FlySpeed SQL Query 3.9.2.0 (Oct 13, 2021)

  • French localization is updated
  • The bug on the Data Export settings form is fixed now.
  • The bug with the Reoprt Options dialog has been fixed.

New in FlySpeed SQL Query 3.9.1.2 (Oct 11, 2021)

  • Metadata Filter: The possibility to filter out unwanted objects by masks is back.

New in FlySpeed SQL Query 3.9.1.1 (Oct 6, 2021)

  • It is now possible to Show/Hide Unused fields for all objects on the Design Pane via the context menu.
  • Minor interface improvements for datasource fields filtration are made.
  • Better placement of new datasources on the query diagram is made.
  • SQL Text Editor: The Ctrl+Delete shortcut is added to remove the token part at the left of the caret. (The Ctrl+Backspace removes the right part.)
  • SQL Text Editor: The Shift+Tab shortcut behavior shortcut has been changed. If there's no selection, it unindents the string if it's on the right of the caret, otherwise moves the caret left.
  • Informix: The bug with missing built-in functions has been fixed.
  • Oracle: The bug with queries containing DbLink objects has been fixed.

New in FlySpeed SQL Query 3.9.1.0 (Oct 1, 2021)

  • Visual Query Builder: You can filter fields in datasources on the Design Pane, and hide unused fields in a single click.

New in FlySpeed SQL Query 3.9.0.3 (Sep 23, 2021)

  • 7-day trials are added.
  • DB Explorer: Query creation and modification dates are shown in the hint.
  • Denodo: Double primary keys fields loading is eliminated.

New in FlySpeed SQL Query 3.9.0.2 (Sep 10, 2021)

  • The bug with scrolling the SQL text to the left is fixed.
  • An exception on trying to execute a query with empty SQL text editor is eliminated.
  • Minor improvements were made.

New in FlySpeed SQL Query 3.9.0.1 (Sep 8, 2021)

  • Now it's possible to switch between statements in the script, edit each SELECT statement in the Visual Query Builder, and execute statements one by one on the SQL Text tab.

New in FlySpeed SQL Query 3.8.5.0 (Aug 3, 2021)

  • 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.

New in FlySpeed SQL Query 3.8.4.3 (Jul 1, 2021)

  • The recently introduced bug with exporting data has been fixed.

New in FlySpeed SQL Query 3.8.4.2 (Jun 30, 2021)

  • 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.

New in FlySpeed SQL Query 3.8.4.1 (Jun 25, 2021)

  • 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.

New in FlySpeed SQL Query 3.8.4.0 (Jun 25, 2021)

  • 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.

New in FlySpeed SQL Query 3.8.3.0 (Jun 9, 2021)

  • 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.

New in FlySpeed SQL Query 3.8.2.0 (May 13, 2021)

  • 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.

New in FlySpeed SQL Query 3.8.1.1 (Mar 6, 2021)

  • 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.

New in FlySpeed SQL Query 3.8.1.0 (Feb 21, 2021)

  • 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.

New in FlySpeed SQL Query 3.8.0.2 (Feb 7, 2021)

  • 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.

New in FlySpeed SQL Query 3.8.0.1 (Feb 3, 2021)

  • 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.
  • Now it's possible to deactivate the tool from the command-line using the "/unregister" switch.
  • 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.

New in FlySpeed SQL Query 3.8.0.0 (Feb 1, 2021)

  • 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.

New in FlySpeed SQL Query 3.7.11.3 (Sep 26, 2020)

  • 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.

New in FlySpeed SQL Query 3.7.11.2 (Jun 1, 2020)

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

New in FlySpeed SQL Query 3.7.11.1 (May 26, 2020)

  • Minor bugs are fixed.

New in FlySpeed SQL Query 3.7.11.0 (May 23, 2020)

  • SQL Text Editor: Editing speed optimizations have been made.
  • Data Export: Encoding (code page) can be changed for CSV and TXT formats.
  • Data Export: Exporting data to XML, encoding is written to the XSD file.
  • Usability of building queries with grouping has been improved by a series of small fixes.
  • SQL Text Editor: Minor fixes and improvements for the suggestions list have been made.
  • Date/time and float values editing is now performed correctly if the display format differs from the system locale.
  • Other minor bug fixes and improvements have been made.

New in FlySpeed SQL Query 3.7.10.2 (Mar 30, 2020)

  • A major problem introduced in the previous build has been fixed. Please accept my apologies for the inconvenience it caused you.
  • Several minor issues have been addressed.

New in FlySpeed SQL Query 3.7.10.0 (Mar 26, 2020)

  • Now it's possible to group connections into folders.
  • Now it's possible to delete several queries or connections with multi-select.
  • Visual Query Builder: Headers of objects are made more contrast.
  • Visual Query Builder: Fields for objects are loaded faster now.
  • SAP HANA: Support for the PLACEHOLDER syntax has been added.
  • Several fixes in the Query Parameter Values form are made.
  • Dutch localization is added (Thanks to Ronald Konijnenburg).
  • Polish localization is updated (Thanks to Witek Szczypka).

New in FlySpeed SQL Query 3.7.9.6 (Feb 21, 2020)

  • The bug with the high CPU load when idle is fixed.
  • PostgreSQL, SQLite: Support for FILTER and fixes in the window functions syntax has been made.
  • SAP Hana: Some optimizations have been made.
  • It is possible now to save the query to connection even if it's closed.
  • Teradata: The bug on editing SQL data has been fixed.
  • Only the currently focused grid is refreshed on pressing the F5 shortcut.

New in FlySpeed SQL Query 3.7.9.5 (Feb 14, 2020)

  • Oracle: Table-valued functions are loaded now.
  • Oracle: Metadata loading performance has been improved.
  • SAP Hana: Table-valued functions are loaded now.
  • SAP Hana: Metadata loading performance has been improved.
  • SAP Hana: Support for TOP clause and other minor fixes are made.

New in FlySpeed SQL Query 3.7.9.4 (Jan 24, 2020)

  • The new feedback dialog allows you to send issues, suggestions and wishes right from the tool (Help - Send your feedback!)
  • The error on opening Expression Editor arising each second time is fixed.
  • Several issues on working with PostgreSQL, Oracle and some other servers have been eliminated.
  • Other minor bugs are fixed.

New in FlySpeed SQL Query 3.7.9.3 (Jan 10, 2020)

  • The bug with executing non-SELECT statements has been fixed.
  • Other minor bug fixes have been made.

New in FlySpeed SQL Query 3.7.9.2 (Jan 6, 2020)

  • The bug with the inability to save the executed query to history has been fixed.
  • The bug with executing a query when the SQL Text tab is hidden has been fixed.

New in FlySpeed SQL Query 3.7.9.1 (Dec 31, 2019)

  • SSL MySQL connection is possible now.
  • The visual work with SELECT queries prefixed by SET and DECLARE statements is possible now (sorry for the mis-announcement in the previous version).
  • Other minor bugfixes and improvements.

New in FlySpeed SQL Query 3.7.9.0 (Dec 18, 2019)

  • Queries and tables with a large number of fields are opened much faster now.
  • The Query Parameter Values form allows to enter list of values for parameters like "IN (:param)".
  • SQL Text Editor: Code auto-completion and auto-indentation have been improved.
  • Visual Query Builder now works with SELECT queries prefixed by SET and DECLARE statements.
  • New properties to tune colors in the SQL Text Editor.
  • Minor bugfixes and improvements have been made.

New in FlySpeed SQL Query 3.7.8.1 (Oct 27, 2019)

  • Numerous fixes and improvements have been made in the suggestion list filtration and autocompletion.

New in FlySpeed SQL Query 3.7.8.0 (Oct 16, 2019)

  • 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.

New in FlySpeed SQL Query 3.7.7.6 (Oct 5, 2019)

  • 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.

New in FlySpeed SQL Query 3.7.7.5 (Jul 12, 2019)

  • Minor bugfixes are made.

New in FlySpeed SQL Query 3.7.7.4 (Jul 10, 2019)

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

New in FlySpeed SQL Query 3.7.7.3 (Jul 6, 2019)

  • 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.

New in FlySpeed SQL Query 3.7.7.2 (Jul 1, 2019)

  • 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.

New in FlySpeed SQL Query 3.7.7.1 (Jun 12, 2019)

  • SQL Text Editor: Minor fixes have been made.
  • SQL Text Editor: The unhandled exception on selecting all text has been fixed.

New in FlySpeed SQL Query 3.7.7.0 (Jun 7, 2019)

  • 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.

New in FlySpeed SQL Query 3.7.6.1 (May 3, 2019)

  • 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.

New in FlySpeed SQL Query 3.7.6.0 (May 2, 2019)

  • 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.

New in FlySpeed SQL Query 3.7.5.5 (Mar 21, 2019)

  • SQL formatting fixes and improvements have been made.
  • The bug with the impossibility to type parentheses has been fixed.
  • The bug with switching to the newly added derived table has been fixed.
  • The bug with not saving the data view settings while working in the Portable mode or in the AppData folder has been fixed.
  • The bug with double scaling of some texts in the SQL Filter builder and the Query Parameters form has been fixed.
  • The bug with the processing of the Unicode NO-BREAK SPACE symbol has been fixed.
  • Pervasive: The list of built-in functions has been updated.

New in FlySpeed SQL Query 3.7.5.4 (Feb 26, 2019)

  • Predefined SQL formatting schemes have been improved, two new schemes were added.
  • MS Excel: The bug with prompting for a file for each new query window has been fixed.
  • Localization fixes have been made, Italian translation has been updated

New in FlySpeed SQL Query 3.7.5.3 (Feb 7, 2019)

  • MS Excel: The new property "Prompt for a file to open upon connection" allows using a single connection to work with different Excel files.
  • PostgreSQL: The new "Charset" property has been added to the Advanced properties.
  • NexusDB: The list of built-in functions is updated.
  • Visual Query Builder: Turning the query into an inconsistent state by unchecking the global Grouping checkbox has been fixed.
  • Direct execution (Ctrl+F5) for ODBC datasources has been improved.
  • The bug with not applying MS Excel data formats on data export is fixed.
  • The German localization for SQL Filter Builder control has been corrected.

New in FlySpeed SQL Query 3.7.5.2 (Dec 21, 2018)

  • The new advanced option for ODBC connections lets deny metadata extraction by means of ODBC driver to overcome specific bugs in the driver causing connection malfunction. It is helpful for some versions of Progress ODBC driver to work with fields containing underscore ("_") symbols. However, this turns off the extraction of primary keys metadata which cannot be retrieved in any other way.

New in FlySpeed SQL Query 3.7.5.1 (Dec 14, 2018)

  • Database Explorer filter control usability is improved.
  • MS Excel connectivity is fixed.
  • PostgreSQL: Slow parsing of queries with INTERVAL and AT TIME ZONE clauses is fixed.
  • Other minor fixes are made.

New in FlySpeed SQL Query 3.7.5.0 (Nov 15, 2018)

  • Support for NexusDB is added.
  • Data export has been speeded-up.
  • Direct SQL query execution is improved: parameters pre-processing is turned off.
  • MySQL: The algorithm for choosing the table whose columns are editable in the query result has been corrected.
  • SQL text auto-completion has been improved.
  • Object filter in the Database Explorer is fixed.
  • Double-click functionality in the Database Explorer is restored.
  • The "SQL text before report" option is fixed.

New in FlySpeed SQL Query 3.7.4.1 (Oct 30, 2018)

  • Code completion has been improved.
  • SAP Hana SQL syntax has been added.
  • Polish translation is updated.
  • The ability to import and export all program settings is added.
  • The movement of settings between locations has been improved.
  • Connection settings are now backed up on each change. Up to 5 backups are stored.
  • Notes are displayed in tooltips for queries in the Database Explorer.
  • Actions to fire totals calculation have been added to the column header's context menu.
  • MySQL: Support for Common Table Expression (WITH clause) has been added.
  • A problem with exporting data from MS SQL Server using Native SQL Client has been hopefully fixed.
  • Re-formatting SQL text doesn't try to connect to a database now.
  • Minor improvements for the data export process have been made.
  • Loading of queries from the history has been fixed.
  • The bug with settings network path to store queries saved in connections has been fixed.
  • Oracle: Ranking functions support has been updated.
  • PostgreSQL: Minor fixes for the EXTRACT function and "AT TIME ZONE" clause have been made.
  • Pervasive: Parsing of date/time builtin functions has been fixed.
  • Other minor bugfixes and improvements have been made.

New in FlySpeed SQL Query 3.7.3.0 (Apr 25, 2018)

  • Support for Pervasive PSQL has been added.
  • GUID formatting options have been added.
  • The new option to hide checkboxes for boolean columns in the data grid has been made.
  • The Ctrl+S shortcut saves new queries to connection rather than to a file.
  • Now it's possible to create SQLite database if one doesn't exist.
  • The information about primary keys now retrieved from ODBC datasources correctly.
  • Localization strings have been updated.
  • The sub-query preview now displays data for sub-queries using CTE correctly.
  • The bug with clearing th Undo buffer after executing the query has been fixed.
  • The Close button on the News form has been fixed.
  • The bug with sorting connections in the 64-bit version has been fixed.

New in FlySpeed SQL Query 3.7.2.4 (Mar 29, 2018)

  • Previously used values for unnamed parameters are restored correctly now.
  • Minor bugfixes have been made.

New in FlySpeed SQL Query 3.7.2.3 (Mar 23, 2018)

  • The bug which caused unhalded exception on editing data in MySQL in datasets with columns which require quotation has been fixed.
  • The bug which prevented reading the registration information from the ini file in the program executable folder has been fixed.

New in FlySpeed SQL Query 3.7.2.2 (Mar 7, 2018)

  • 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 bugsfixes and improvements have been made.

New in FlySpeed SQL Query 3.7.2.0 (Feb 22, 2018)

  • 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.

New in FlySpeed SQL Query 3.7.1.2 (Jan 26, 2018)

  • 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.

New in FlySpeed SQL Query 3.7.1.1 (Jan 26, 2018)

  • 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.

New in FlySpeed SQL Query 3.7.1.0 (Jan 16, 2018)

  • 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.

New in FlySpeed SQL Query 3.7.0.5 (Jan 5, 2018)

  • 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

New in FlySpeed SQL Query 3.7.0.3 (Dec 28, 2017)

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

New in FlySpeed SQL Query 3.7.0.2 (Dec 27, 2017)

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

New in FlySpeed SQL Query 3.7.0.0 (Dec 22, 2017)

  • 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.

New in FlySpeed SQL Query 3.5.7.4 (Nov 16, 2017)

  • New shortcuts are available in the Query Columns List of the Visual Query Builder:
  • Alt+Delete - Delete the current/selected row(s).
  • Alt+Insert - Add new row before the current one.
  • Alt+[Arrow Up/Down] - Move the current/selected row(s) up or down.
  • Other minor bug fixes have been made.

New in FlySpeed SQL Query 3.5.7.3 (Nov 8, 2017)

  • Minor bug fixes in SQL formatting and SQL syntax have been made.
  • Data view layout doesn't save now for unnamed unsaved queries now.
  • A memory leak has been eliminated.

New in FlySpeed SQL Query 3.5.7.2 (Oct 27, 2017)

  • Small improvements in the list of available master-detail relationships have been made.
  • Improvements and bugfixes in the list of linked objects for datasources on Design Pane have been made.
  • Improvements in the Company News and auto-update What's New have been made.
  • Downloading of the new version can be canceled now.
  • The bug with not bringing the application to the front on opening a query from the Explorer has been fixed.
  • Other minor improvements and bug fixes have been made.

New in FlySpeed SQL Query 3.5.7.1 (Oct 11, 2017)

  • Now it's possible to enter parameters of stored procedure (table-valued function in MS SQL) after it's got added to the query in the Visual Query Builder using the Datasource Properties dialog
  • The new option "Deny data export optimizations" has been added to the Advanced tab of Connection Properties dialog. Turn it on in case you have errors during the data export like "Invalid cursor position", etc
  • Other minor improvements and bug fixes have been made

New in FlySpeed SQL Query 3.5.7.0 (Sep 29, 2017)

  • SQL Formatting: new options to format sub-queries and conditional expressions (IF and CASE) have been added
  • Plenty of minor bug fixes and minor improvements have been made

New in FlySpeed SQL Query 3.5.6.3 (Sep 17, 2017)

  • The bug with resetting MySQL server host to "localhost" has been fixed.
  • The bug with not saving server versions for some database servers has been fixed.
  • SQL formatting options have been redesigned.
  • Dynamically indented SQL formatting has been improved.
  • Minor bug fixes and ipmpovements have been fixed.

New in FlySpeed SQL Query 3.5.6.2 (Sep 13, 2017)

  • Italian localization has been added. Thanks to Fabio Santacaterina for
  • his hard work.
  • DB2: The new property "Retrieve metadata from ODBC driver" has been added.
  • It is set by default to True as this way is faster and takes DSN settings
  • into account, but in this mode descriptions for tables and fields cannot
  • be retrieved.
  • SQL formatting option to place comma on the next line before the next item
  • in the list (SELECT, ORDER BY, GROUP BY) has been added.
  • PostgreSQL: The bug with not retrieving foreign keys has been fixed.
  • Localization updates, forms beautifying, HiDPI fixes and other bug fixes
  • have been made.

New in FlySpeed SQL Query 3.5.6.1 (Sep 6, 2017)

  • Parameterized queries can be previewed now.
  • You can change parameter values via the special bar above the Data grid now.
  • DB2: Descriptions for tables are extracted now.
  • DB2: The SQL_ERROR problem on trying to connect to AS/400 database version lower than 7 has been fixed.
  • PostgreSQL: Incorrect displaying of UUID fields has been fixed.
  • Localizations are updated.

New in FlySpeed SQL Query 3.5.6.0 (Sep 5, 2017)

  • The Connection Parameters form has been redesigned.
  • Now it's possible to display descriptions for database objects.
  • Turn on the "Show metadata object descriptions" property on the Database
  • Explorer tab in the General Program Settings dialog.
  • Text Editor: Selection movement on indent/unindent commands has been
  • eliminated.
  • Text Editor: The bug in Replace command in selection has been fixed.
  • Localization files have been updated, missing strings have been added.
  • Other minor improvements and bug fixes have been made.

New in FlySpeed SQL Query 3.5.5.1 (Aug 19, 2017)

  • The new "Write ODBC trace to connection log" connection option has been added to the Advanced tab for ODBC and DB2 connection types.
  • More missing strings have been added to the Default.lng file

New in FlySpeed SQL Query 3.5.5.0 (Aug 16, 2017)

  • Memory and speed optimizations for Data Export process have been made.
  • German localization has been added.
  • Localization fixes have been made.
  • Icons are scaled properly now on hi-resolution monitors.
  • Execution of non-SELECT statements or SELECT statements prefixed by
  • DECLARE or SET statements has been simplified: no need to hold down the Ctrl key.

New in FlySpeed SQL Query 3.5.4.1 (Jul 11, 2017)

  • Minor bugs have been fixed.

New in FlySpeed SQL Query 3.5.4.0 (Jul 7, 2017)

  • Folding SQL scripts by statements is possible now.
  • Several bugs in the filter builder have been fixed.
  • Other minor bugs have been fixed

New in FlySpeed SQL Query 3.5.3.0 (Jun 26, 2017)

  • The Expression Editor ellipsis button in Expression column of the Query Columns Grid doesn't hide the combo box button in the inline editor but displayed next to it.
  • Large delay on opening the Expression Editor in the case of large database schema has been fixed.
  • The bug with incorrect loading of conditions joined with the topmost OR operator has been fixed.
  • Minor bugs have been fixed.

New in FlySpeed SQL Query 3.5.2.0 (Jun 10, 2017)

  • It is possible now to connect through the SSH tunnel to a database host which differs from the 'localhost'.
  • The bug with loading of date/time filter with BETWEEN operator on the Query Results tab has been fixed.
  • Minor bugs in the Query Parameters Values dialog have been fixed.

New in FlySpeed SQL Query 3.5.1.3 (Jun 2, 2017)

  • The critical bug with incorrect SQL query generation has been fixed.
  • The new 100k limit of displayed records has been added.
  • Loading of the SQL filter builder conditions has been fixed.
  • The error on resizing SQL text editor has been fixed.
  • The bug on formatting SQL text in the query window with unassigned
  • database connection has been fixed.

New in FlySpeed SQL Query 3.5.1.2 (May 26, 2017)

  • Oracle: The bug with retrieving fields for synonyms has been fixed.
  • The bug with the query text formatting on the SQL Text tab has been fixed.
  • Minor bugs have been fixed.

New in FlySpeed SQL Query 3.5.1.1 (May 23, 2017)

  • Now it is possible to select PostgreSQL database from the list.
  • Now it is not possible to display all records at once in the results data grid if fetching on demand is disabled. You can turn on this option on the Advanced tab of Connection Properties dialog.
  • Minor bugfixes and improvements have been made.

New in FlySpeed SQL Query 3.5.1.0 (May 21, 2017)

  • The popup edit box does not appear above the row now on pressing Ctrl+F keys in the Data Grid. Users can manage their search via the new panel below the grid.
  • The Incremental Search button is displayed now in the Data Grid toolbar.It lets turn on and off moving down to the record corresponding to the characters you type and highlighting them.
  • The new "SQL" button on the Data Grid toolbar has been added. It displays the currently executed SQL query text in a message box.
  • Now the text of SQL query is displayed in the error message box when an error occurs during the SQL query execution.
  • The bug with not applying the default database name for PostgreSQL connections has been fixed.
  • The bug with not saving the list of selected databases between work sessions has been fixed.
  • Some bugs in the SQL filter builder have been fixed.

New in FlySpeed SQL Query 3.5.0.2 (May 17, 2017)

  • Now it's possible to add new detail view from the cell popup menu for fields with a foreign key constraint.
  • The tool now prompts if the SQL file opened from Explorer is already edited. The user can choose to save edits to another file, to discard changes and reopen the file or to continue editing.
  • The bug with applying Database property for different connection types
  • has been fixed.
  • Retrieving the list of databases for MS SQL Server and MySQL has been fixed.
  • Detail views are closed automatically now if a corresponding field is missing in the query results.
  • Minor improvements and bug fixes have been made.

New in FlySpeed SQL Query 3.5.0.1 (May 4, 2017)

  • The bug with adding new connections has been fixed.
  • ODBC, DB2 connection types: The new option "Fetch records on demand" has been added to the Advanced tab of Connection Properties dialog.
  • DB2: The "ODBC Driver" option has been moved to the main tab of Connection Properties dialog. Note that this option is global and needs program restart to be applied.
  • Other minor bug fixes and improvements have been made.

New in FlySpeed SQL Query 3.5.0.0 (May 3, 2017)

  • Now it is possible to cancel loading the list of databases from server in the Connection Properties dialog and Create New Connection wizard.
  • The bug with scrolling the text editor using scroll bars has been fixed.
  • The bug with the cursor not aligning with the last line being edited has been fixed.
  • MS SQL Server: The bug with setting table lock on the server while browsing the data has been fixed. Now data has been completely loaded to the grid. Users can limit the number of loaded records using the combo box on the toolbar and on the Advanced tab of Connection Properties. If you want to get back to the previous behavior, set the "Fetch records on demand" option on the Advanced tab of Connection Properties.
  • Loading metadata from DB2 iSeries has been improved.
  • Minor bug fixes have been made.

New in FlySpeed SQL Query 3.4.9.6 (Apr 18, 2017)

  • Problems with metadata retrieval from DB2 iSeries have been fixed.
  • Few minor bugfixes have been made.

New in FlySpeed SQL Query 3.4.9.5 (Apr 12, 2017)

  • The bug with restoring filters for DateTime fields has been fixed.
  • The tool is now operable on Windows Server 2016.
  • PostgreSQL: Execution of SQL scripts with temporary tables has been fixed.
  • Minor bugs have been fixed.

New in FlySpeed SQL Query 3.4.9.4 (Apr 6, 2017)

  • The bug with opening the tool in Portable mode has been fixed.
  • The bug with unwanted prompts to save connection properties while working in the Mixed mode has been fixed.

New in FlySpeed SQL Query 3.4.9.3 (Apr 4, 2017)

  • Several bugs have been fixed.

New in FlySpeed SQL Query 3.4.9.2 (Mar 31, 2017)

  • Command timeout setting has been added for PostgreSQL connections.
  • Several bugs have been fixed.

New in FlySpeed SQL Query 3.4.9.1 (Mar 30, 2017)

  • Some memory leaks have been eliminated.
  • Bug reports sending has been fixed.

New in FlySpeed SQL Query 3.4.9.0 (Mar 29, 2017)

  • Ability to display detail data sets below the data grid has been made.
  • Users can select detail datasets to display according to the foreign keys
  • or by specifying corresponding fields between the master and detail tables
  • manually. It is possible now to define two levels of details.
  • Data view configuration is now saved between work sessions.
  • Now it's possible to define several SQL formatting schemes and to switch
  • between them quickly right in the query builder window. The button to
  • switch scheme can be found on the Query Builder tab at the right of the
  • SQL text editor.
  • Data filter builder has been improved. The new "in list" and "not in list"
  • operators have been added. The ability to look up for referenced table or
  • distinct values for a column has been made.
  • SSH connection to Oracle databases has been implemented.
  • SSH authentication using key files is possible now.
  • Oracle: Prompt to change the password on expiring is displayed now.
  • The new popup menu on Data Grid column headers allows hiding of column
  • and sorting by it.
  • SQL Text Editor suggestion list and autocompletion have been improved.
  • Multiline SQL Expression Editor look has been improved.
  • PostgreSQL: New object types are displayed in the Database Explorer now:
  • materialized views, TOAST tables, and foreign tables.
  • Minor SQL parsing improvements for Oracle, MySql, Firebird and IBM DB2
  • have been made.
  • Lots of other bugfixes and minor improvements have been made.

New in FlySpeed SQL Query 3.3.3.3 (Dec 5, 2016)

  • The bug with incorrect parsing of queries with aggregate functions introduced in the version 3.3.3.2 is fixed

New in FlySpeed SQL Query 3.3.3.2 (Dec 4, 2016)

  • The "WSAGetLastError" error message on reconnecting after SSH connection timed out has been fixed
  • The "Cannot focus a disabled or invisible window" error on executing a query has been fixed
  • List of valid identifiers has been corrected
  • Minor bug fixes have been made

New in FlySpeed SQL Query 3.3.3.1 (Nov 23, 2016)

  • The "Driver ID is not defined." error when connecting to ODBC datasource introduced in the previous build has been fixed.

New in FlySpeed SQL Query 3.3.3.0 (Nov 23, 2016)

  • The new Teradata connection type has been added
  • Scrolling by mouse wheel is possible now in the drop-down list of Expression cell editor in the Visual Query Builder's columns grid
  • Line numbers gutter can be shown now in the SQL Text Editor
  • MySQL SSH connection timeout is set equal to the Login timeout setting
  • User SQL formatting is now kept on switching from the SQL Text Editor to the Visual Query Builder on the Query Builder tab
  • The bug with Excel sheet names with the '$' sign has been fixed

New in FlySpeed SQL Query 3.3.2.0 (Nov 15, 2016)

  • The new bar has been added to the Sub-query Preview tab to display the total number of records returned by this subquery.
  • Descriptions are now shown in hints for the nodes of Database Explorer.
  • Ability to show descriptions for fields in the datasource field lists on the Design Pane has been added. The "Object fields list view style"
  • option on the "Query Builder" - "Design Pane" tab of the Program Options dialog lets tune this option.
  • It is now possible to cancel sorting by a column in the data grid by clicking on the column header with the Ctrl or Shift key pressed.
  • The new option to automatically fit the width of a newly added datasource by its content (field name and type) has been added to the
  • Program Options dialog on the "Query Builder" - "Design Pane" tab.
  • The new option to define the default value to limit the number of rows visible at a time has been added to the Advanced tab of the Connection Properties dialog.
  • The Query Info tab now displays native data type names and sizes where it's possible.
  • Lots of minor fixes and improvements in the Query Builder and the SQL Text Editor tabs of the Query window have been made.

New in FlySpeed SQL Query 3.3.1.12 (Nov 3, 2016)

  • Hang after data export to .xslx has been fixed.
  • Cursor positioning on selecting text with the mouse has been improved.

New in FlySpeed SQL Query 3.3.1.11 (Nov 3, 2016)

  • The Search and Replace functionality in the SQL Text Editor has been improved: highlighting of all found occurrences of text, ability to continue the search from the beginning, ability to search only in selected text, a progress bar on replacing multiple fragments have been made.
  • The bug with sorting in the Data grid by a column, which alias is equal to the field name has been fixed.
  • PostgreSQL: Support for custom aggregate functions has been added.
  • PostgreSQL: Date/time parts have been added to the list of valid identifiers.
  • MS SQL Server: CHAR(n) parser ambiguity has been fixed.
  • MS SQL Server: CHAR and NCHAR, ROW and ROWS are added to the list of valid identifiers.
  • Firebird: The simple form of the TRIM function is supported now.
  • Oracle: Special form of the TRIM function is supported now.

New in FlySpeed SQL Query 3.3.1.10 (Sep 8, 2016)

  • General changes:
  • Date format in SQL text for AdvantageDB and FoxPro (DBF files) has been changed to "MM/dd/ccyy" (default).
  • Cancellation of record editing should be confirmed now.
  • Minor improvements in data editing in the grid are made.
  • SQL Text Editor:
  • The bug with suggestion list being displayed above the Query Builder window on different tabs is fixed now.
  • Minor improvements in the logic of displaying of suggestion list window are made.
  • The "Search again"(F3) shortcut works now even if the Search dialog has been hidden.
  • Other minor improvements and bug fixes are made.

New in FlySpeed SQL Query 3.3.1.9 (Aug 3, 2016)

  • Ctrl-C shortcut had stopped working to copy selected records in the Data Grid after copying a value in the grid inplace cell editor. Fixed now
  • Values of BCD data type are formatted now according to the Grid numeric data format settings now
  • Visual query builder now parses fine SQL queries with grouping by integer indexes of columns

New in FlySpeed SQL Query 3.3.1.8 (Aug 3, 2016)

  • The bug with missing Query Columns Grid in Visual Query Builder is fixed.
  • The problem with large fonts in Visual Query Builder with scaling is fixed.

New in FlySpeed SQL Query 3.3.1.7 (Aug 3, 2016)

  • The "Range check error" and "List index out of bounds" errors are fixed.

New in FlySpeed SQL Query 3.3.1.5 (Aug 3, 2016)

  • SQL Text formatting:
  • If word wrapping is enabled in query formatting properties, wrapped text is properly indented now.
  • The "Global Indent" SQL formatting option works fine now.
  • SQL Syntax:
  • Informix: Support for date builtin functions like YEAR is fixed.
  • MS SQL Server: Support for new DatePart items (ISO_WEEK, TZOffset, ...) is made.
  • Visual Query Builder:
  • Linked Objects menu: a table wouldn't been added to query if such object already presents in this sub-query.
  • Unnamed columns from derived tables aren't shown on the Design Pane in parent query.
  • Column aliases aren't used anymore in the GROUP BY clause if server doesn't support that.

New in FlySpeed SQL Query 3.3.1.4 (Jul 8, 2016)

  • The problem typing special characters on some european keyboard layouts is fixed
  • Minor bugs are fixed

New in FlySpeed SQL Query 3.3.1.3 (Jul 8, 2016)

  • Data grid popup menu is improved. Inapplicable items are disabled now
  • A new item to clear filter for a column is added
  • The Filter pane on Result Data tab is shown collapsed now if it was hidden before applying filter by shortcut (Ctrl+Q) or using popup menu
  • Superfluous dot or space after closing the suggestion window is eliminated
  • Problems with switching the Query Builder and SQL text tabs while working with sub-queries are fixed
  • Incorrect saving of query layout when Query Builder's design pane is scrolled down is fixed

New in FlySpeed SQL Query 3.3.1.2 (Jun 25, 2016)

  • Weird bug with the 'e' key not typed after executing a query is fixed.
  • Minor improvements in displaying SQL text editor suggestion list and
  • code autocompletion are made.

New in FlySpeed SQL Query 3.3.1.1 (Jun 25, 2016)

  • Mouse wheel scrolling is fixed
  • Typing special characters in SQL text editor using Alt key is fixed
  • Other minor bug fixes are made

New in FlySpeed SQL Query 3.3.1.0 (Jun 25, 2016)

  • Keyboard shortcuts in other controls than text editor are fixed.
  • The bug with height of multiline editors in the Form View is fixed.
  • Layout of the Visual Query Builder tab is restored correctly and
  • resized proportionally now.
  • Undo in Visual Query Builder is back.
  • Text editor background color is changeable now.
  • The "Auto insert brackets" option works fine now.
  • Other minor fixes are made.

New in FlySpeed SQL Query 3.3.0.4 (Jun 25, 2016)

  • The problem with missing text cursor on the SQL Text tab is fixed.

New in FlySpeed SQL Query 3.3.0.2 (Jun 25, 2016)

  • Several bugs are fixed.
  • Copy/paste shortcuts works fine now.
  • Minor improvements in the SQL text editor are made.
  • Toolbar customiszer is restored.

New in FlySpeed SQL Query 3.3.0.1 (Jun 25, 2016)

  • New SQL Text Editor with code completion and syntax highlight is made
  • Ability to preview SQL query sample while tuning SQL formatting options
  • is added
  • Minor improvements and bug fixes are made

New in FlySpeed SQL Query 3.2.5.19 (Mar 29, 2016)

  • The bug with very small and squished together lines in Database Explorer on displays with large and extra large fonts is fixed
  • An opportunity to apply registration from a temporary file is made
  • Minor bugfixes are made

New in FlySpeed SQL Query 3.2.5.18 (Mar 29, 2016)

  • The bug with very small and squished together lines in Database Explorer on displays with large and extra large fonts is fixed.
  • An opportunity to apply registration from a temporary file is made.

New in FlySpeed SQL Query 3.2.5.17 (Mar 24, 2016)

  • Several bug fixes and improvements in Visual Query Builder are made:
  • Query Column List Control now always displays the "Delete row" button.
  • Design Pane: Aggregated fields are checked now in Datasource controls.
  • The TAB key behaviour in the last column of Select List is corrected.
  • Fitting of the Query Column List's column width on double clicking on
  • the column splitter is made.
  • Firebird: Domain name is shown now instead of type name in datasource
  • field lists.
  • The bug with applying "is (not) empty" filter to resultset on string fields
  • is fixed.
  • Changes made to criteria of invisible cells weren't applied to the
  • query. Fixed now.
  • The error with quotation of sub-query text in the cells of Select List
  • Control is fixed.
  • Loading of subqueries from condition cells for "IN (subquery)"
  • expressions is fixed.
  • MS SQL Server: Support for COLLATE clause for column expressions.
  • Access Violation in the "Remove CTE" event handler is eliminated.

New in FlySpeed SQL Query 3.2.5.16 (Dec 28, 2015)

  • Incremental search is not activated when cell editor is shown.
  • Filter bar is displayed on applying filter via the shortcut (Ctrl+Q) or using the context menu; filtration is canceled on hiding the filter bar.
  • Minor bugfixes are made.

New in FlySpeed SQL Query 3.2.5.15 (Dec 10, 2015)

  • An option to force resultset retrieval on executing non-SELECT queries is made visible through the drop-down menu of Execute toolbar button.
  • Non-select queries are opened on the SQL Text tab by default.
  • Minor bugfixes and improvements are made.

New in FlySpeed SQL Query 3.2.5.14 (Dec 4, 2015)

  • The bug on clicking on the "*" item of the datasource fields list is fixed.
  • Polish localization is added.
  • Parsing and autocorrection of unquoted string literals, date constants and enumerations typed in the Criteria column cells of the Visual Query Builder is improved.
  • Other minor bug fixes and improvements are made.

New in FlySpeed SQL Query 3.2.5.12 (Nov 13, 2015)

  • Minor improvements in the Visual Query Builder are made.
  • Parameters used in SQL expressions can be turned off separately in the Query Parameter Values dialog.
  • The bug with date picker is fixed.

New in FlySpeed SQL Query 3.2.5.11 (Nov 10, 2015)

  • Unhandled exception on selecting XML data export type is addressed.
  • Delays on connecting to generic OLE DB or ODBC datasources with database server autodetection are significantly reduced.

New in FlySpeed SQL Query 3.2.5.10 (Nov 3, 2015)

  • Some more performance optimizations are made.
  • The "Range Check error" on exporting to Excel datasets with large amount of columns is fixed.
  • Some SQL syntax fixes are made.

New in FlySpeed SQL Query 3.2.5.9 (Oct 30, 2015)

  • More speed optimizations for working with datasets with large number of columns are made.
  • Problems with connecting to Progress OpenEdge database server are fixed.
  • Other minor fixes and improvements are made.

New in FlySpeed SQL Query 3.2.5.8 (Oct 30, 2015)

  • Opening data views with thousands of columns is performed times faster now
  • The error on parsing queries containing "d" identifiers is fixed
  • Minor bugs are fixed

New in FlySpeed SQL Query 3.2.5.7 (Oct 21, 2015)

  • The new option not to quote text fields in exported CSV files is added.
  • Several minor bugs are fixed.

New in FlySpeed SQL Query 3.2.5.6 (Oct 12, 2015)

  • Access violation on switching from sub-query to the main query is fixed.

New in FlySpeed SQL Query 3.2.5.5 (Oct 9, 2015)

  • The "Range check error" on connecting to Teradata through ODBC is fixed.
  • The problem with Interbase and some other DBs passwords containing special symbols is fixed.
  • Saving metadata filters is fixed.
  • Minor UI bug fixes are made.

New in FlySpeed SQL Query 3.2.5.4 (Jul 6, 2015)

  • MySQL SUBSTRING(a FROM b TO c) clause is supported.
  • Editing of TOP clause for Advantage DB is fixed.
  • Minor bug fixes and usability improvements are made.

New in FlySpeed SQL Query 3.2.5.3 (Jun 13, 2015)

  • Minor bug fixes are made.

New in FlySpeed SQL Query 3.2.5.1 (Jun 13, 2015)

  • Filters and sortings applied on the Data tab are preserved after re-executing the query or refreshing a dataset.
  • The bug with not saving password for Firebird and InterBase is fixed.
  • Minor bugs are fixed.

New in FlySpeed SQL Query 3.2.4.3 (Jun 1, 2015)

  • Bugs in the 'Single "SELECT" sub-query' mode are fixed.
  • The new option to show the Data Filter Bar by default is made.
  • Incremental search in the Lookup Data Grid is fixed.
  • Minor improvements in the Data Filter Bar are made.

New in FlySpeed SQL Query 3.2.4.2 (May 21, 2015)

  • Collation can be set for Advantage DB connections now.
  • The bug with linked tables in sub-queries for Oracle database is fixed.

New in FlySpeed SQL Query 3.2.4.1 (May 13, 2015)

  • Multiple rows selection in the Query Columns Grid is made to allow for easy query columns re-ordering in the Query Builder.
  • Performance of the Sub-query Results Preview is improved.
  • "TABLE()" function is supported in ANSI SQL/2003 syntax. It matters for use with the NexusDB and some other databases.
  • Minor bug fixes in the Filter Builder on the Data tab are made.

New in FlySpeed SQL Query 3.2.3.2 (May 8, 2015)

  • Minor improvements in the Query Parameter Values dialog are made.
  • The bug in the Filter Builder on the Data tab with DateTime fields is corrected.
  • Operability of the tool under Wine is restored.
  • Some minor bugs are fixed.

New in FlySpeed SQL Query 3.2.3.1 (May 2, 2015)

  • Query Parameter Values form now supports Time and Timestamp values.
  • User name is now requested among with a database password if it's not specified in connection properties.
  • User is now prompted to restart after successful registering or unregistering the tool.
  • The Aggregate column is moved closer to the Grouping column in Visual Query Builder's Query Columns Grid.
  • Other minor improvements and bug fixes are made.

New in FlySpeed SQL Query 3.2.2.1 (Apr 15, 2015)

  • Cancellation of SQL query execution is processed in another thread.
  • Cancellation of MS Access queries is disabled as it's not possible to do this.
  • Possible errors on updating datasets built from queries with the LIMIT clause in MySQL are fixed.
  • Other minor bug fixes and improvements are made.

New in FlySpeed SQL Query 3.2.1.1 (Apr 7, 2015)

  • Metadata retrieval and SQL execution performance is improved.
  • Minor fixes in Criteria Builder on the Data tab are made.
  • Minor bug fixes and improvements are made.

New in FlySpeed SQL Query 3.2.0.3 (Mar 27, 2015)

  • Width of columns of the Query Columns grid on the Query Builder tab is saved between work sessions now.
  • The "Show query text on the separate tab" option is preserved now. Turning this option off will hide the "SQL Text" tab for new query windows, but it still will be shown for non-SELECT or invalid SELECT queries.
  • Field lists in Criteria Builder on the Data tab are filled correctly.
  • Other minor bug fixes and improvements are made.

New in FlySpeed SQL Query 3.2.0.2 (Mar 25, 2015)

  • Errors executing incorrect queries are fixed.

New in FlySpeed SQL Query 3.2.0.1 (Mar 24, 2015)

  • The new visual control is added above the data grid to allow for adding filters and applying them to result dataset.
  • Ability to alphabetically sort connections in the Database Explorer is made.
  • Ability to display queries saved in connections without establishing database connection is made.
  • The bug with not applying most recent changes on executing a query when editing query column item in the Query Builder is fixed.

New in FlySpeed SQL Query 3.1.0.9 (Mar 6, 2015)

  • The bug with creating sub-query in expression is fixed.

New in FlySpeed SQL Query 3.1.0.8 (Mar 3, 2015)

  • Toolbars on the Query Builder tab are re-designed.
  • Re-format query function is corrected.
  • The error with editing query text with CTE in the default "Sub-query with unions" text edit mode is fixed.
  • Other minor improvements and fixes are made.

New in FlySpeed SQL Query 3.1.0.7 (Feb 25, 2015)

  • The "Re-format query" button is added back to the Query Builder tab.
  • The bug with not saving the folder to store queries in connection is fixed.
  • The bug with incorrect opening of some queries is fixed.
  • Other minor bug fixes and improvements are made.

New in FlySpeed SQL Query 3.1.0.5 (Feb 20, 2015)

  • The bug with empty connection list is fixed.
  • The bug with not applying or even loosing the ORDER BY clause is fixed.
  • Error message dialog for database server errors is improved.

New in FlySpeed SQL Query 3.1.0.3 (Feb 19, 2015)

  • The "Control has no parent window" bug is fixed.
  • Problems with creating and saving queries with CTE are fixed.
  • Ability to show full query text on the Query Builder tab is restored. Use the right-most button on the toolbar to switch to this mode.
  • Minor bugs are fixed.

New in FlySpeed SQL Query 3.1.0.2 (Feb 18, 2015)

  • The bug with Portable registration is fixed.
  • Some bugs with query window not assigned to any DB connection are fixed.

New in FlySpeed SQL Query 3.1.0.1 (Feb 18, 2015)

  • The Query Parameter Values form is improved.
  • The new SQL Text tab is added to the Query window.
  • The text editor on the Query Builder tab now displays the text of the currently active sub-query in the query builder. Breadcrumbs are displayed to determine position of the currently visible sub-query to allow for quick navigation to outer sub-queries.
  • Ability to preview query and sub-query results is added.
  • SQL query parsing error message is replaced with the hint panel.
  • Support for Advantage DB SQL syntax is made.
  • Support for Pervasive SQL syntax is made.
  • The interface is now correctly scaled when large fonts are used.
  • The new option "Disable SQL sorting and filtration" is added.
  • The new option is added for exporting data to OpenXML (.xlsx) format to automatically fit columns width by content.
  • Ability to change the program settings storage location is made.
  • Ability to save the connection log to file for debug purposes is made. The "Write connection log" option is added to advanced connection properties. The "Connection name".log file can be found in the "%USERPROFILE%AppDataLocalActiveDBSoftFlySpeed SQL Query" folder.
  • Messages about errors arising during the metadata loading process are now displayed correctly.

New in FlySpeed SQL Query 3.0.2.4 (Oct 25, 2014)

  • SQL query parsing error message is replaced with the hint panel above the SQL text editor.
  • Text layout error on saving print data to PDF is corrected.
  • Form View in Data Only windows works fine now.

New in FlySpeed SQL Query 3.0.2.3 (Oct 18, 2014)

  • The new option is added for exporting data to OpenXML (.xlsx) format to automatically fit columns width by content. This feature may require considerable resources in case of large amount of data.
  • The "Bookmark is not found for dataset" error on trying to export data to .xslx format is fixed.

New in FlySpeed SQL Query 3.0.2.2 (Oct 17, 2014)

  • The bug with hanging the program on typing the double quote symbol at the end of the query text is fixed.
  • The bug on showing empty space below the SQL text editor on the Query Builder tab after swithing between query windows if visual query builder is turned off is fixed.
  • Minor bug fixes are made.

New in FlySpeed SQL Query 3.0.2.1 (Oct 16, 2014)

  • The bug with not opening queries saved in connection is fixed.

New in FlySpeed SQL Query 3.0.2.0 (Oct 15, 2014)

  • Fonts in Visual Query Builder are scaled correctly now.
  • Better resolving of column naming conflicts is made.
  • Alises are assigned to unnamed columns automatically now.
  • Field Type column is added in the Expressions query statistics grid.
  • Hints for connections are shown in the Database Explorer.
  • Column widths on exporting data to XLS and XSLX are corrected.
  • It is now possible to fit column widths by the content.
  • "Copy column names" option is fixed.
  • The bug with incorrect creation of links for multi-column foreign keys when manually created using the Linked Objects button is fixed.
  • The bug with Quick Search feature (Ctrl+F) in the Data Grid is fixed.
  • MySQL: Time values greater than 24 hours are displayed correctly now. Unfortunately it is still not possible to write such values in the grid.
  • MS SQL Server, Oracle: Parametrized queries are used to fetch field lists (reduces database server load).
  • MySQL: Quoted characters in string literals are supported now.
  • PostgreSQL: RECURSIVE keyword in WITH clause is supported now.
  • Firebird: WEEK date part is supported now.
  • Minor bugs are fixed.

New in FlySpeed SQL Query 3.0.1.3 (Sep 2, 2014)

  • The Ctrl+W shortcut is added to close the current MDI child window.
  • Fetching limit setting is saved automatically now.
  • Query layout is saved correctly on renaming a query in the tree.
  • Few minor bug fixes and SQL parsing improvements are made.

New in FlySpeed SQL Query 3.0.1.2 (Aug 14, 2014)

  • Now the tool switches to the "Mixed mode" when found the settings "FlySpeed SQL Query.ini" file in the program installation folder being registered in Desktop mode. This allows for read-only access to connection settings stored in the .ini file, but using the registry for saving the rest of user settings.
  • The tool does not allow for changing of the user queries folder in the Mixed mode.
  • The bug with collapsing the Database Explorer tree on metadata loading is fixed.
  • The Access voilaton error on running query in a separate window when different connection is selected in the Database Explorer is fixed.

New in FlySpeed SQL Query 3.0.1.1 (Aug 5, 2014)

  • The "Provider cannot be found" is fixed.
  • MS SQL Server: Native Client 11 connection strings are fixed.

New in FlySpeed SQL Query 3.0.1.0 (Aug 1, 2014)

  • The "Autofit columns width" button is added to the Data grid toolbar.
  • The new properties to control behavior on double-click on database objects and saved queries in the Database Explorer are added.
  • The new property to control sorting of fields in datasources on Design area of the Query Builder is added.
  • The new property to control docking of the Query window toolbar to the main window is added.
  • Drag-n-drop of objects, fields and saved queries to the SQL text editor is possible now.
  • Schema name is skipped now when database objects are grouped by schema in the Database Explorer tree.
  • Query windows toolbar is improved.
  • Adjusting control's height in the Query Builder tab on decreasing Query window height is made now.
  • Exporting Time values to .xls Excel file is fixed.
  • Setting of column widths when exporting to Excel is corrected.
  • The bug with not opening the master password prompt is fixed.
  • Japaneese language is updated.
  • Displaying XML and GIF files in BLOB view is corrected.
  • Advanced cconnect options to group objects by schema and type are fixed.
  • Date formats are fixed in Report view.
  • Errors on trying to get access to inaccessible folders of queries saved in connection are handled correctly now.
  • Many other minor fixes and improvements are made.

New in FlySpeed SQL Query 3.0.0.3 Beta (Jul 6, 2014)

  • The new options to group objects in the database explorer by schema and object type, to hide system objects, and to expand grouping node automatically are added to the advanced connection properties.
  • The bug with not expanding table fields in the database objects tree is fixed.
  • The bug with not updating columns orders in the data grid on changing it in the query is fixed.
  • The error on executing non-SELECT statement is corrected.
  • The bug with incorrect setting of date separator in the data grid is fixed.
  • Other minor bugs are fixed.
  • Language files are updated; unused items are removed.

New in FlySpeed SQL Query 3.0.0.2 Beta (Jun 13, 2014)

  • New database password prompt dialog is made.
  • All types of connections work correctly now.
  • Information about foreign keys is loaded correctly.
  • Connection to SQLite is possible in normal (not exclusive) mode only.

New in FlySpeed SQL Query 3.0.0.1 Beta (Jun 10, 2014)

  • Execution of non-SELECT statements is possible now.
  • Prompting for password for MySQL connections is fixed.
  • Editing data in MySQL is fixed.

New in FlySpeed SQL Query 3.0.0.0 Beta (Jun 9, 2014)

  • Query Layout and SQL History are saved between work sessions now.
  • Table data can be browsed and edited without building a query.
  • Multiple records deletion is possible now.
  • Copying and pasting single cell data without entering into the cell data edit mode.
  • The problem on opening a query before the metadata is completely loaded is fixed now.
  • Query cancellation is functioning properly in all the cases now.
  • Timestamp and Date parameters are fixed.

New in FlySpeed SQL Query 2.10.1.8 (Mar 25, 2014)

  • "Charset" option to connect to non-Unicode MySQL databases is added to the Advanced tab. Turn off the "Use Unicode" option to take effect of this one.
  • Local port for SSH connections is determined automatically now.
  • ANSI standard DATETIME'dd/mm/yyyy' literals are supported now.
  • Other minor fixes are made.

New in FlySpeed SQL Query 2.10.1.7 (Mar 19, 2014)

  • SQLite: User is prompted now to create a new database if database file does not exist.
  • SQLite: Now it's possible to select exclusive or shared locking mode.
  • Advantage DB: Support of Left/Right and other built-in functions is made.
  • FoxPro (*.DBF files) connections: Result data is editable now.
  • FoxPro: Records marked as deleted are hidden now.
  • MySQL: Setting Connection timeout option to zero means timeout disabling.
  • MySQL: Incorrect setting of SSH port is fixed.
  • InterBase/Firebird: Creation of new connection with default user password ('masterkey') is fixed now.
  • Data export core is updated.

New in FlySpeed SQL Query 2.10.1.6 (Jan 25, 2014)

  • The bug with prolongation of portable version is fixed.
  • Minor fixes in PostgreSQL, Firebird and MySQL syntax parsers are made.
  • Other minor fixes are made.

New in FlySpeed SQL Query 2.10.1.5 (Dec 27, 2013)

  • Adding object to the query by double clicking or dragging from the database schema tree is performed correctly and does not cause any errors now.
  • Other minor bug fixes and SQL syntax improvements are made.

New in FlySpeed SQL Query 2.10.1.4 (Dec 17, 2013)

  • Localization is corrected.
  • Double click on the History grid cells is fixed.
  • The "!Name" and "&Name" sequences were skipped from the query for many connection types. Fixed now.

New in FlySpeed SQL Query 2.10.1.3 (Nov 28, 2013)

  • The "dsHistoryData: Missing data provider or data packet" error is fixed.

New in FlySpeed SQL Query 2.10.1.1 (Nov 20, 2013)

  • Ability to cancel the data export process is made.
  • The new "Set to Null" context menu item is added to the Data Grid.
  • The new option "Quote everything" for exporting data to *.CSV is made.
  • Ability to specify text values for null-valued fields and boolean constants while exporting data in text formats (*.TXT, *.CSV) is restored.
  • The bug with connecting to incorrect MySQL host in case of using login prompt for multiple MySQL connections is fixed.
  • The error message caused by attempt to decrypt empty password string is eliminated.

New in FlySpeed SQL Query 2.10.0.8 (Oct 15, 2013)

  • Keyboard shortcuts are added to the Save Query prompt window.
  • Fixed bug with showing of existing field values list in the Filter toolbar if some filters are already applied.
  • Other minor bugfixes are made.

New in FlySpeed SQL Query 2.10.0.7 (Oct 12, 2013)

  • The new option for PostgreSQL connection type is added to specify location of the PostrgeSQL client library (libpq.dll). It can be found on the Advanced tab of the Connection Properties dialog.

New in FlySpeed SQL Query 2.10.0.6 (Oct 11, 2013)

  • Minor improvements in the Add Linked Objects menu are made.
  • PostgreSQL client libraries are replaced.
  • Minor bugs are fixed.

New in FlySpeed SQL Query 2.10.0.5 (Oct 9, 2013)

  • The bug with incorrect password saving for new connections is fixed.
  • The Server version setting was not saved for some connection types. Fixed now.
  • Other minor bug fixes are made.

New in FlySpeed SQL Query 2.10.0.4 (Oct 7, 2013)

  • The "ORA-01017: invalid username/password" error on re-connecting after the program restart is fixed.
  • The "Driver ID is not defined." error on browsing for default database is fixed.

New in FlySpeed SQL Query 2.10.0.3 (Oct 5, 2013)

  • MySQL: The "No database selected" error is fixed.

New in FlySpeed SQL Query 2.10.0.2 (Oct 5, 2013)

  • The "Stream read error" is fixed.

New in FlySpeed SQL Query 2.10.0.1 (Oct 5, 2013)

  • Ability to encode database and SSH passwords stored in settings with the Master password is made. Use the "Connection" - "Set Master Password" command in main menu for this purpose.
  • The new button is now shown at the right of the focused datasource on Design pane to allow easy adding of linked objects to the query.
  • Query layout is now preserved after parsing of the modified query.
  • Algorithm of automatic objects placement on the diagram pane is improved.
  • PostgreSQL connection library is updated.
  • The "Show SQL query text" report generation option works now.
  • Other minor fixes and improvements are made.

New in FlySpeed SQL Query 2.9.9.2 (Jun 27, 2013)

  • Recently introduced bug that led to emptiness of field lists in visual query builder is fixed now.

New in FlySpeed SQL Query 2.9.9.1 (Jun 24, 2013)

  • A workaround is made to work with Netezza database using PostgreSQL connection type.
  • Other minor bug fixes are made.

New in FlySpeed SQL Query 2.9.7.4 (May 13, 2013)

  • Executing a query with the Ctrl key pressed (by clicking the Execute button or by pressing the F5 or F9 keys) instructs to return resultset for a command even it is not treated as a valid SELECT statement due to presence of leading DECLARE or SET or any other SQL statements.
  • Few SQL syntax fixes are made.

New in FlySpeed SQL Query 2.9.7.3 (Apr 12, 2013)

  • Command and connection timeout options are added for MySQL connections.
  • SQL formatting options for Join conditions works now.
  • Zooming in Print preview works now.
  • DB2 connection without alias definition is possible now.
  • SQL parsing and generation fixes are made.
  • Few minor bugs are fixed.

New in FlySpeed SQL Query 2.9.7.2 (Mar 16, 2013)

  • Sorting is fixed once again.
  • The error on trying to filter by unique identifier field is fixed now.
  • Other minor bug fixes are made.

New in FlySpeed SQL Query 2.9.7.1 (Mar 6, 2013)

  • Sorting and filtration is fixed for some database servers.

New in FlySpeed SQL Query 2.9.7.0 (Feb 27, 2013)

  • Now it's possible to sort and filter result data by almost each grid column (excluding those that were defined via complex SQL expression without alias).
  • The collapse/expand button is added to each datasource on the viaual query builder's diagram pane.
  • The "Add new Union Sub-Query" (+) button is added to the Union navigation bar.
  • Now it's possible to highlight even rows of the visual query builder's Query Columns Grid with alternate background color.
  • The new options are added to take control over the new features.

New in FlySpeed SQL Query 2.9.6.13 (Feb 8, 2013)

  • The bug with not saving print preview settings is fixed.
  • The bug with applying limits for DB2 databases is fixed.
  • The bug with Sybase ASE server autodetection is fixed.
  • Result query data of FoxPro (DBF) and Advantage DB connections were always in Read-only mode. Fixed now.

New in FlySpeed SQL Query 2.9.6.12 (Feb 4, 2013)

  • Support of Teradata SQL Syntax is added. Use the new syntax with generic ADO and ODBC connection types.
  • Minor bug fixes are made.

New in FlySpeed SQL Query 2.9.6.11 (Nov 19, 2012)

  • Binary(16) field values are displayed as GUIDs now.
  • Unregistration of Portable version is possible now.
  • SQL parser is speeded up.
  • MS SQL Server 2012: Support of ROW and RANGE clauses in OVER expression is made.

New in FlySpeed SQL Query 2.9.6.10 (Nov 10, 2012)

  • Result dataset limits are not applied now if a query already contains such limitations.
  • High CPU loading on the Data tab is eliminated.
  • Query Builder: Calculation of optimal datasource height is fixed.
  • Other minor bugfixes are made.

New in FlySpeed SQL Query 2.9.6.9 (Nov 5, 2012)

  • A bug that caused error on running non-SELECT statements is fixed.
  • A bug that caused locking on running incorrect queries is fixed.

New in FlySpeed SQL Query 2.9.6.8 (Nov 1, 2012)

  • The bug on creating new ODBC connection is fixed.
  • Other minor bugfixes are made.

New in FlySpeed SQL Query 2.9.6.7 (Oct 31, 2012)

  • Software copy protection technology was changed for compatibility with Windows 8.
  • Old registration keys will not be changed, but the tool will have to obtain the new key for each installation. This will be done automatically on starting the application.
  • In order to use the software in Portable mode, please submit a request to obtain a portable registration key.
  • Database access libraries were updated.

New in FlySpeed SQL Query 2.9.6.6 (Sep 26, 2012)

  • The new data formtting options for the Print View tab allows to define format of Date and Time data types and to specify fixed decimal point for numeric data.
  • The NULL value of boolean fields is shown as an empty cell now.
  • Minor bug fixes in Data Export are made.

New in FlySpeed SQL Query 2.9.6.5 (Sep 24, 2012)

  • The new SQL Dialect option is added for Firebird connection type.
  • Minor fixes in displaying of float fields in the grid are made.

New in FlySpeed SQL Query 2.9.6.4 (Sep 21, 2012)

  • Command Timeout setting is added to Oracle, Firebird, InterBase, SQLite and ODBC connection types. It can be found at the Advanced tab of Connection Proerties dialog.
  • The "ORA-02248: invalid option for ALTER SESSION" error is fixed.

New in FlySpeed SQL Query 2.9.6.3 (Sep 21, 2012)

  • The tool works with Windows 8 now.

New in FlySpeed SQL Query 2.9.6.2 (Sep 7, 2012)

  • Memory leaks are eliminated.
  • An error on trying to check for updates on startup is not shown.

New in FlySpeed SQL Query 2.9.6.1 (Sep 7, 2012)

  • Print View tab is moved into the Data tab.
  • Exception on changing the records limit when query is running is fixed.
  • Few memory leaks are eliminated.

New in FlySpeed SQL Query 2.9.6.0 (Sep 7, 2012)

  • Ability to limit the number of fetched records is made. The new toolbar is added to the Data tab.
  • Errors on using the BLOB Editor are fixed.
  • MS SQL command timeout setting on using the OLE DB connection type is fixed.
  • The "malformed trail byte or out of range char" error on executing MySQL queries with BINARY and VARBINARY types in resultset is fixed.
  • Occasional exceptions caused by simultaneous updating and reading of metadata are eliminated.

New in FlySpeed SQL Query 2.9.5.9 (Sep 7, 2012)

  • The new options are added to format numeric values in the grid: Number of decimal digits and Fixed decimal point.

New in FlySpeed SQL Query 2.9.5.8 (Sep 7, 2012)

  • BCD fields are not formatted as Currency anymore.
  • Sorting in grid by fields that need to be quoted is fixed.
  • The unneccesary re-building of the visual query builder is removed.

New in FlySpeed SQL Query 2.9.5.7 (Sep 7, 2012)

  • Data sorting, columns order and visibility are applied to the data export now.
  • The Windows toolbar is made to browse and switch query windows with ease.
  • Exception on changing sub-query tabs in the query parts editing mode is fixed.
  • Filtration by boolean fields is fixed.

New in FlySpeed SQL Query 2.9.5.6 (Sep 7, 2012)

  • Independent editing of sub-queries is fixed. Now the whole query is not replaced with sub-query after it's editing.
  • Saving of port and host for PostgreSQL SSH connections is fixed.
  • Timeouts for MS SQL server (Native client connection method) are fixed.

New in FlySpeed SQL Query 2.9.5.5 (Sep 7, 2012)

  • Boolean fields are displayed as checkboxes in the Data grid now.
  • Now it's possible to use DSA authentication algorithm for SSH tunneling.
  • Now it's possible to edit sub-query text independently of the main query.The new button is added to the Query Builder tab toolbar to set this mode on.
  • PostgreSQL port does not change now after connecting through SSH tunnel.
  • Now it's possible to execute non-SELECT statements for Advantage, FoxPro and DBF connections.

New in FlySpeed SQL Query 2.9.5.4 (Sep 7, 2012)

  • Now it is possible to setup data formats for the data grid. The appropriate button is added to the Data tab toolbar.
  • The status bar is added to the query window to display query execution time and number of fetched records.
  • The unavailability of PostgreSQL client library won't cause exception now.
  • The bug with changing connection for a query is fixed now.

New in FlySpeed SQL Query 2.9.5.3 (Sep 7, 2012)

  • The error message on executing SQL queries slower that 1 sec is fixed.
  • The error on executing a parameterised query (using named notation) for MS SQL Server with native connection method is fixed.
  • SQL text does not disappear on changing connection for a query window.
  • Other minor bugfixes are made.

New in FlySpeed SQL Query 2.9.5.0 (Dec 26, 2011)

  • Connection through SSH thunnel is made for PostgreSQL databases.
  • "Like" and "Not like" operators are added to the quick filter bar.
  • The "Read-only" yellow panel is gone. It is replaced with the dialog.
  • Incremental search is reworked. It is activated now with the "Ctrl+F" keys.
  • The bug with search and replace shortcuts in SQL text editor is fixed.

New in FlySpeed SQL Query 2.9.4.13 (Nov 23, 2011)

  • Stored password for MS SQL Server was applied incorrectly in case of using SQL Native Client connection. Fixed now.
  • The bug with occasional changing of loaded queries is fixed.

New in FlySpeed SQL Query 2.9.4.12 (Nov 22, 2011)

  • MySQL: Ability to connect through SSH and HTTP tunnels is made. Read the answer at the F.A.Q. page to learn how to connect through HTTP tunnel.
  • MS SQL Server: Now it's possible to sort and filter result data for queries with unions.
  • MS SQL Server connection dialog: "Use alternate connection method" checkbox is replaced with the "Connection method" combobox.
  • PostgreSQL client library is updated to version 9.1.0.
  • Several memory leaks are eliminated, minor bug fixes are made.

New in FlySpeed SQL Query 2.9.4.11 (Nov 22, 2011)

  • The new option "Use alternate connection method" is added to MS SQL Server
  • connection properties dialog to switch between OLE DB connection (not checked)
  • and native SQL client connection (checked).
  • Visual Query Builder: Support of ORDER BY in queries with unions is improved.
  • Visual Query Builder: Parsing speed optimizations are made.
  • Minor bug fixes are made.

New in FlySpeed SQL Query 2.9.4.10 (Nov 22, 2011)

  • The bug with not drawing text on active tabs is fixed.
  • Minor bug is fixed.

New in FlySpeed SQL Query 2.9.4.9 (Oct 28, 2011)

  • Parsing and working with large queries in Visual Query Builder is speeded up. Connection and command timeout settings are added for Oracle, Firebird, InterBase and IBM DB2.
  • OS authentication option is added to InterBase and Firebird connections.
  • Transaction Isolation Level property is added to MS SQL Server connections.
  • List of built-in functions for PostgreSQL is added to the SQL parser.
  • Now it's not possible to disconnect or switch connection for the query window when SQL query is executing.
  • Skins are applied to the Database Explorer tree now.
  • Minor bugfixes are made.

New in FlySpeed SQL Query 2.9.4.8 (Oct 13, 2011)

  • MS SQL Server: "FOR XML" clause is updated to support Ms Sql Server "Denali".
  • MySQL: COALESCE, GREATEST, LEAST and INTERVAL added to the list of builtin functions.
  • PostgreSQL: Function "substring('test',1,2)" is converted to "substring('test' from 1 for 2)" on parsing the query.
  • Firebird: INT type alias is supported.
  • AV when editing the query columns list in rare cases is fixed.
  • The bug on trying to sort results when query is still executing is fixed.

New in FlySpeed SQL Query 2.9.4.6 (Oct 6, 2011)

  • MS SQL Server connection is reverted to using ADO (OLE DB).
  • Setting *.sql files association from Options dialog works fine now in Windows 7.
  • Files opened with the tool from Explorer are added to the Recent documents now.
  • Minor bug fixes are made.

New in FlySpeed SQL Query 2.9.4.0 (Aug 23, 2011)

  • Localization is possible now. Russian translation is available.
  • Moving columns in data grid is possible by dragging column headers.
  • Lookup data is possible in filter toolbar for fields with foreign keys.
  • Connection to Advantage DB databases is possible now.
  • DB2 and MS SQL Server connections now use different components to get access to corresponding database servers.
  • Minor bug fixes are made.

New in FlySpeed SQL Query 2.9.3.6 (Jul 28, 2011)

  • Range check error on closing maximized query window on multi-monitor systems is fixed.
  • Incremental search in query results is made. It may be switched off using the button on the Data View tool bar.
  • ANSI SQL/89 syntax is added for generic ADO and ODBC connections.

New in FlySpeed SQL Query 2.9.3.5 (Jul 19, 2011)

  • Now it's possible to setup data formatting options for Print View from the Report Options dialog at the Data Formats tab.
  • The access violation at address 00404A9B bug is fixed.
  • Some dialogs were displayed at wrong screen on multi-monitor systems. Fixed now.

New in FlySpeed SQL Query 2.9.3.4 (Jul 19, 2011)

  • The new command "Create New Query From Selected Text" is added.
  • Now you may define any column delimiter when exporting data to CSV.
  • "Refresh Metadata" popup menu item is added for grouping nodes in the tree.
  • "Create links from relations" options is made default for new connections.
  • Command timeouts were not applied to correctly for ADO-based connections. Fixed now.
  • "Show query builder by default" setting wasn't saved. Fixed now.
  • BLOB View: Unicode data is saved to Memo and Varchar fields correctly now.
  • Bugs with Report Options dialog are fixed.
  • Few icons are added to beautify the tool.

New in FlySpeed SQL Query 2.9.3.2 (Jul 19, 2011)

  • The "Create links from relations" option is set by default for the new connections. Please check it in the Advanced tab of the Connection Properties dialog if you don't get your objects automatically linked on adding them to the query.
  • PostgreSQL data access components are updated.
  • Error on dropping an object to the query builder when "Create links by identical field names" options is on is fixed.
  • Fixed error on closing the the Report Options dialog with OK button.
  • Fixed error when result set has more than 255 text or memo fields.
  • Fixed the "Cannot perform this operation on a closed dataset" error that happened sometimes on closing a query for MS SQL Server with bit fields.

New in FlySpeed SQL Query 2.9.3.1 (Jun 9, 2011)

  • Access violation error is fixed when opening connection in the Connection Properties dialog for internal needs (retrieving the list of databases).
  • MS SQL Server: Table and query hints are supported; join hints are parsed fine now, but not preserved due to architecture limitations.
  • SQLite: Parsing of sub-queries in condition cells is fixed.
  • MySQL: UNSIGNED is treated as a valid data type now.

New in FlySpeed SQL Query 2.9.3.0 (Jun 3, 2011)

  • Ability to query FoxPro *.DBF files directly, without an intermediate layer (OLE DB Provider or ODBC Driver) is made. Use the new "FoxPro (*.DBF Files)" connection type to get direct access to these files.
  • The tool proposes to save settings to the user's Application Data folder if failed to switch to the Portable Mode, i.e. to save settings to the program installation folder due to insufficient rights.
  • The problem with wrong parsing of "AS UNSIGNED" clause for MySQL is fixed.

New in FlySpeed SQL Query 2.9.2.5 (May 13, 2011)

  • Second instance crashed if opened without command line parameters. Fixed now.
  • Comments were lost in SQL text even if the Query Builder is hidden. Fixed now.
  • The "Save password" setting was not restored in Mysql connection properties. Fixed now.

New in FlySpeed SQL Query 2.9.2.4 (May 12, 2011)

  • The bug with adding sub-query in expression for PostgreSQL dialect is fixed.
  • The "System Error. Code:_87. Wrong parameter." error on starting the tool is fixed.

New in FlySpeed SQL Query 2.9.2.3 (May 5, 2011)

  • Automatic set of aliases for the same named columns is made. A message is shown if the user defines columns with same names.
  • Few bugs are fixed.

New in FlySpeed SQL Query 2.9.2.2 (May 5, 2011)

  • The bug with executing queries with complex expressions or aggregates is fixed.

New in FlySpeed SQL Query 2.9.2 (Apr 28, 2011)

  • Ability to browse related table to lookup the value for referenced field is
  • made in the Form View. Lookup window saves it's position, fields order and
  • sorting, shown/hidden columns between work sessions for each lookup table.
  • The new property is added to Advanced Connection Options to instruct the
  • query builder to create joins in WHERE clause instead of creating ANSI JOINS.
  • The new property is added to Advanced Connection Options to instruct the
  • query builder to create links by identical field names. Can be useful for
  • legacy databases which have no foreign keys defined.
  • Few minor bug fixes are made.

New in FlySpeed SQL Query 2.9.1.6 (Apr 26, 2011)

  • The tool is capable now to retrieve foreign keys from SQLite databases.
  • Embedded SQLite functions are supported now by Visual Query Builder.
  • Some access violation and other errors are fixed.
  • Some memory leaks are eliminated.
  • Few minor bugs are fixed.

New in FlySpeed SQL Query 2.9.1.5 (Apr 26, 2011)

  • The new "Add CTE" button is added to the query builder toolbar that allows
  • to add new or insert existing CTE to the query.
  • A menu is shown now on dropping a saved query to Design Pane asking to add
  • this query as Derived Table or as CTE.
  • SQL formatting options for Common Table Expressions are added.
  • "Ancestor for 'SpTBXPanel1' not found"
  • Notification for a possible problem with connecting to Oracle under 64-bit
  • Windows versions is added. See the F.A.Q. page for details.

New in FlySpeed SQL Query 2.9.1.3 (Apr 26, 2011)

  • Bug with converting double backslashes to single in Portable mode is fixed.
  • more reliable rare errors handling is made.

New in FlySpeed SQL Query 2.9.1.2 (Apr 26, 2011)

  • The "Same as Main Query format" option is added to the SQL text formatting
  • options of Expression Sub-queries and Derived Tables.
  • "Maximim object height" option is added to the Query Builder visual options.
  • Now the tool saves the height of SQL text editor and the height of Query
  • Columns Grid automatically.

New in FlySpeed SQL Query 2.9.1.1 (Apr 26, 2011)

  • ODBC connection form is updated:
  • "Launch ODBC Administrator" and "Create new ODBC DataSource" buttons;
  • Connection Timeout and Command Timeout are moved to additional props;
  • Username and Password can be saved now in connection properties.
  • Moving connection queries on changing Global queries path is made.
  • Ability to cancel moving queries to a new location is made.
  • The Global Query Path is stored relatively now if set to default folder or
  • it's sub-folders.
  • The "Set to default folder" button is added to the Options dialog.
  • On changing the Portable mode setting the user is asked to move the Saved
  • queries to appropriate location.
  • Execution of SELECT statements only is allowed in Read-only mode.
  • MS Access and MySQL Login Prompt dialogs are back.
  • The bug with incorrect creation of sub-folder in the queries folder is fixed.
  • Unnecessary query builder update on executing SQL Query is removed.
  • Memo fields were not exported to OpenXML format. Fixed now.
  • Timestamp fields export to MS Excel error is fixed.
  • Passwords were saved in connection properties despite of the "Save password"
  • setting. Fixed now.

New in FlySpeed SQL Query 2.9.1.0 (Mar 16, 2011)

  • Export to Open XML spreadsheet is made.

New in FlySpeed SQL Query 2.9.0.0 (Feb 26, 2011)

  • SQL Queries with Common Table Expressions (CTE) can be built visually now.
  • Ability to edit BLOB fields in various formats (HTML, RTF, browse and load images, etc.)
  • Ability to edit data in the Form View. This will ease editing of MEMO fields.
  • Ability to calculate totals in the Grid View.
  • Ability to review the SQL History and get back to any previously executed query.
  • Ability to change physical folder to store queries "in connection".
  • Many minor usability and SQL syntax improvements are made.
  • Minor bug fixes are made.

New in FlySpeed SQL Query 2.7.7.0 (Apr 26, 2010)

  • Many bug fixes are made.
  • Oracle, PostgreSQL, InterBase, Firebird, Generic ODBC connections are rebuilt with better data access components.
  • SQLite direct access is added.
  • Data Grid is completely remaked.
  • Numerous improvements in SQL parsing are made.
  • Ability to build queries with Common Table Expressions visually is implemented.
  • Other minor improvements are made.

New in FlySpeed SQL Query 2.6.9 (Jan 7, 2010)

  • SQL Query Tool now allows you to save queries in sub-folders is added.
  • SQL Query Tool now allows you to specify encoding on exporting data to CSV and Text files is made.
  • Now it's possible to filter queries and database objects in the tree.
  • Minor usability improvements and bug fixes are made.

New in FlySpeed SQL Query 2.6.0 (May 28, 2009)

  • Ability to copy data to the clipboard is made;
  • Quick sorting by multiple columns is possible now;
  • Quick filter toolbar is added to the query results tab;
  • Ability to deny data modification for the current query results is made;
  • Pipe delimiter is added to CSV Export options.

New in FlySpeed SQL Query 2.5.7 (Apr 11, 2009)

  • Portable installation is possible now.
  • Autoconnect on start-up option is added.
  • Syntax and usability improvements in Visual Query Builder are made.
  • Ability to drag fields from the query building area to the columns pane is made.
  • Other minor improvements and bug fixes.

New in FlySpeed SQL Query 2.2 (Aug 6, 2008)

  • Field types are shown at the Query building area now.
  • Objects were sorted alphabetically in descending order. Fixed now.
  • CPU usage was non-zero in idle. Fixed now.
  • Minor fixes in MySQL parser.
  • Other minor improvements and bugfixes.

New in FlySpeed SQL Query 2.1.0 (Jul 15, 2008)

  • New connection option is added for MS Excel spreadsheets.
  • Support of MS Office 2007 file formats (MS Excel, MS Access) is implemented.
  • Advanced connection settings are available now.
  • Visual query builder and other minor improvements are made.

New in FlySpeed SQL Query 2.0.0 (Jun 16, 2008)

  • Export to Excel, CSV, Text and XML files is implemented
  • Ability to use previously saved queries as derived tables is made
  • Visual query builder User interface is improved.
  • Many other minor improvements and bugfixes are made.