Release History

FlySpeed SQL Query History

October 05, 2013

- The "Stream read error" is fixed.

October 04, 2013

+ Ability to encode database and SSH passwords stored in settings with the 
  Master password is made. Use the "Connection" - "Set Master Password" command
  in main menu for this purpose.
+ The new button is now shown at the right of the focused datasource on Design
  pane to allow easy adding of linked objects to the query.
+ Query layout is now preserved after parsing of the modified query.
+ Algorithm of automatic objects placement on the diagram pane is improved.
= PostgreSQL connection library is updated.
- The "Show SQL query text" report generation option works now.
- Other minor fixes and improvements are made.

June 27, 2013

- Recently introduced bug that led to emptiness of field lists in visual 
  query builder is fixed now.

June 24, 2013

= A workaround is made to work with Netezza database using PostgreSQL 
  connection type.
- Other minor bug fixes are made.

May 13, 2013

- Executing a query with the Ctrl key pressed (by clicking the Execute 
  button or by pressing the F5 or F9 keys) instructs to return resultset 
  for a command even it is not treated as a valid SELECT statement due to
  presence of leading DECLARE or SET or any other SQL statements.
- Few SQL syntax fixes are made.

April 12, 2013

+ Command and connection timeout options are added for MySQL connections.
- SQL formatting options for Join conditions works now.
- Zooming in Print preview works now.
- DB2 connection without alias definition is possible now.
- SQL parsing and generation fixes are made.
- Few minor bugs are fixed.

March 15, 2013

- Sorting is fixed once again.
- The error on trying to filter by unique identifier field is fixed now.
- Other minor bug fixes are made.

March 06, 2013

- Sorting and filtration is fixed for some database servers. 

February 27, 2013

= Now it's possible to sort and filter result data by almost each grid column
  (excluding those that were defined via complex SQL expression without alias).
+ The collapse/expand button is added to each datasource on the viaual query 
  builder's diagram pane.
+ The "Add new Union Sub-Query" (+) button is added to the Union navigation bar.
+ Now it's possible to highlight even rows of the visual query builder's 
  Query Columns Grid with alternate background color.
+ The new options are added to take control over the new features.

February 08, 2013

- The bug with not saving print preview settings is fixed.
- The bug with applying limits for DB2 databases is fixed.
- The bug with Sybase ASE server autodetection is fixed.
- Result query data of FoxPro (DBF) and Advantage DB connections 
  were always in Read-only mode. Fixed now.