Release History

FlySpeed SQL Query History

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.

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

July 07, 2016

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

June 29, 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
- 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.

June 24, 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.

June 23, 2016

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

June 22, 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.

June 15, 2016

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

June 14, 2016

- A few bugs are fixed.