Release History

FlySpeed SQL Query History

November 22, 2016

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

November 21, 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.

November 14, 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.

November 02, 2016

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

October 29, 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
- 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
- Firebird: The simple form of the TRIM function is supported now.
- Oracle: Special form of the TRIM function is supported now.

September 07, 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.

August 02, 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.


July 20, 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.

July 19, 2016

- The "Range check error" and "List index out of bounds" errors are fixed.
  (sorry for the previous incorrect fix)

July 18, 2016

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