FlySpeed SQL Query
Release History
- November 21, 2016
FlySpeed SQL Query 3.3.3.0 changelog
+ 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.
- November 14, 2016
FlySpeed SQL Query 3.3.2.0 changelog
+ 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.
- November 02, 2016
FlySpeed SQL Query 3.3.1.12 changelog
- Hang after data export to .xslx has been fixed. = Cursor positioning on selecting text with the mouse has been improved.
- October 29, 2016
FlySpeed SQL Query 3.3.1.11 changelog
+ 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.
- September 07, 2016
FlySpeed SQL Query 3.3.1.10 changelog
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.
- August 02, 2016
FlySpeed SQL Query 3.3.1.9 changelog
- 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.
- July 20, 2016
FlySpeed SQL Query 3.3.1.8 changelog
- 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.
- July 19, 2016
FlySpeed SQL Query 3.3.1.7 changelog
- The "Range check error" and "List index out of bounds" errors are fixed. (sorry for the previous incorrect fix)
- July 18, 2016
FlySpeed SQL Query 3.3.1.6 changelog
- The "Range check error" and "List index out of bounds" errors are fixed.
- July 15, 2016
FlySpeed SQL Query 3.3.1.5 changelog
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.