FlySpeed SQL Query
Release History
- February 19, 2015
FlySpeed SQL Query 3.1.0.3 changelog
- 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.
- February 18, 2015
FlySpeed SQL Query 3.1.0.2 changelog
- The bug with Portable registration is fixed. - Some bugs with query window not assigned to any DB connection are fixed.
- February 17, 2015
FlySpeed SQL Query 3.1.0.1 changelog
+ 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.
- October 24, 2014
FlySpeed SQL Query 3.0.2.4 changelog
= 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.
- October 18, 2014
FlySpeed SQL Query 3.0.2.3 changelog
+ 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.
- October 17, 2014
FlySpeed SQL Query 3.0.2.2 changelog
- 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.
- October 15, 2014
FlySpeed SQL Query 3.0.2.1 changelog
- The bug with not opening queries saved in connection is fixed.
- October 14, 2014
FlySpeed SQL Query 3.0.2.0 changelog
+ Fonts in Visual Query Builder are scaled correctly now. + Better resolving of column naming conflicts is made. + Aliases 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. We hope to fix this problem soon. = 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.
- September 02, 2014
FlySpeed SQL Query 3.0.1.3 changelog
+ 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.
- August 13, 2014
FlySpeed SQL Query 3.0.1.2 changelog
= 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.