Release History

FlySpeed SQL Query History

May 29, 2015

- Bugs in the 'Single "SELECT" sub-query' mode are fixed.
+ The new option to show the Data Filter Bar by default is made.
- Incremental search in the Lookup Data Grid is fixed.
= Minor improvements in the Data Filter Bar are made.

May 21, 2015

+ Collation can be set for Advantage DB connections now.
- The bug with linked tables in sub-queries for Oracle database is fixed.

May 13, 2015

+ Multiple rows selection in the Query Columns Grid is made to allow for
  easy query columns re-ordering in the Query Builder.
= Performance of the Sub-query Results Preview is improved. 
+ "TABLE()" function is supported in ANSI SQL/2003 syntax. It matters 
  for use with the NexusDB and some other databases.
- Minor bug fixes in the Filter Builder on the Data tab are made.

May 08, 2015

= Minor improvements in the Query Parameter Values dialog are made.
- The bug in the Filter Builder on the Data tab with DateTime fields
  is corrected.
- Operability of the tool under Wine is restored. 
- Some minor bugs are fixed.

May 01, 2015

= Query Parameter Values form now supports Time and Timestamp values.
= User name is now requested among with a database password if it's 
  not specified in connection properties.
= User is now prompted to restart after successful registering or
  unregistering the tool.
= The Aggregate column is moved closer to the Grouping column in 
  Visual Query Builder's Query Columns Grid.
= Other minor improvements and bug fixes are made.

April 15, 2015

+ Cancellation of SQL query execution is processed in another thread.
= Cancellation of MS Access queries is disabled as it's not possible
  to do this.
- Possible errors on updating datasets built from queries with the 
  LIMIT clause in MySQL are fixed.
- Other minor bug fixes and improvements are made.

April 07, 2015

+ Metadata retrieval and SQL execution performance is improved.
- Minor fixes in Criteria Builder on the Data tab are made.
- Minor bug fixes and improvements are made.

March 27, 2015

+ Width of columns of the Query Columns grid on the Query Builder tab
  is saved between work sessions now.
= The "Show query text on the separate tab" option is preserved now.
  Turning this option off will hide the "SQL Text" tab for new query
  windows, but it still will be shown for non-SELECT or invalid SELECT
- Field lists in Criteria Builder on the Data tab are filled correctly.
- Other minor bug fixes and improvements are made.   

March 24, 2015

- Errors executing incorrect queries are fixed.

March 23, 2015

+ The new visual control is added above the data grid to allow for 
  adding filters and appying them to result dataset.
+ Ability to alphabetically sort connections in the Database Explorer 
  is made.
+ Ability to display queries saved in connections without establishing
  database connection is made.
- The bug with not applying most recent changes on executing a query
  when editing query column item in the Query Builder is fixed.