FlySpeed SQL Query

Release History

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.

July 07, 2016

FlySpeed SQL Query 3.3.1.4 changelog

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

June 29, 2016

FlySpeed SQL Query 3.3.1.3 changelog

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

June 24, 2016

FlySpeed SQL Query 3.3.1.2 changelog

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