FlySpeed SQL Query

Release History

July 13, 2011

FlySpeed SQL Query 2.9.3.4 changelog

+ The new command "Create New Query From Selected Text" is added.
+ Now you may define any column delimiter when exporting data to CSV.
+ "Refresh Metadata" popup menu item is added for grouping nodes in the tree.
= "Create links from relations" options is made default for new connections.
- Command timeouts were not applied to correctly for ADO-based connections.
  Fixed now.
- "Show query builder by default" setting wasn't saved. Fixed now.
- BLOB View: Unicode data is saved to Memo and Varchar fields correctly now.
- Bugs with Report Options dialog are fixed.
= Few icons are added to beautify the tool.

June 22, 2011

FlySpeed SQL Query 2.9.3.2 changelog

= The "Create links from relations" option is set by default for the new 
  connections. Please check it in the Advanced tab of the Connection Properties
  dialog if you don't get your objects automatically linked on adding them to
  the query.
= PostgreSQL data access components are updated.
- Error on dropping an object to the query builder when "Create links by
  identical field names" options is on is fixed.
- Fixed error on closing the the Report Options dialog with OK button.
- Fixed error when result set has more than 255 text or memo fields.
- Fixed the "Cannot perform this operation on a closed dataset" error that 
  happened sometimes on closing a query for MS SQL Server with bit fields.

June 09, 2011

FlySpeed SQL Query 2.9.3.1 changelog

- Access violation error is fixed when opening connection in the Connection
  Properties dialog for internal needs (retrieving the list of databases).
+ MS SQL Server: Table and query hints are supported; join hints are parsed
  fine now, but not preserved due to architecture limitations.
- SQLite: Parsing of sub-queries in condition cells is fixed.
- MySQL: UNSIGNED is treated as a valid data type now.

June 03, 2011

FlySpeed SQL Query 2.9.3.0 changelog

+ Ability to query FoxPro *.DBF files directly, without an intermediate layer 
  (OLE DB Provider or ODBC Driver) is made. Use the new "FoxPro (*.DBF Files)"
  connection type to get direct access to these files.
= The tool proposes to save settings to the user's Application Data folder if
  failed to switch to the Portable Mode, i.e. to save settings to the program
  installation folder due to insufficient rights.
- The problem with wrong parsing of "AS UNSIGNED" clause for MySQL is fixed.

May 19, 2011

FlySpeed SQL Query 2.9.2.7 changelog

+ Minor improvements in Visual Query Builder are made.
- The "#08501 Bad handshake" error on connecting to MySQL v.5.5.12 is fixed now.
- The "Range check error" on trying to execute a query on some PCs is fixed.

May 15, 2011

FlySpeed SQL Query 2.9.2.6 changelog

- The "Show visual query builder by default" option is fixed now.
- The "Word wrap" option was not preserved. Fixed now.

May 12, 2011

FlySpeed SQL Query 2.9.2.5 changelog

- Second instance crashed if opened without command line parameters. Fixed now.
- Comments were lost in SQL text even if the Query Builder is hidden. Fixed now.
- The "Save password" setting was not restored in Mysql connection properties. 
  Fixed now.

May 11, 2011

FlySpeed SQL Query 2.9.2.4 changelog

- The bug with adding sub-query in expression for PostgreSQL dialect is fixed.
- The "System Error. Code:_87. Wrong parameter." error on starting the tool is
  fixed.

May 04, 2011

FlySpeed SQL Query 2.9.2.3 changelog

+ Automatic set of aliases for the same named columns is made. A message is shown
  if the user defines columns with same names.
- Few bugs are fixed.

April 29, 2011

FlySpeed SQL Query 2.9.2.2 changelog

- The bug with executing queries with complex expressions or aggregates is fixed.