FlySpeed SQL Query

Release History

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.

April 27, 2011

FlySpeed SQL Query 2.9.2 changelog

+ Ability to browse related table to lookup the value for referenced field is
  made in the Form View. Lookup window saves it's position, fields order and 
  sorting, shown/hidden columns between work sessions for each lookup table.
+ The new property is added to Advanced Connection Options to instruct the
  query builder to create joins in WHERE clause instead of creating ANSI JOINS.
+ The new property is added to Advanced Connection Options to instruct the
  query builder to create links by identical field names. Can be useful for
  legacy databases which have no foreign keys defined.
- Few minor bug fixes are made.

April 23, 2011

FlySpeed SQL Query 2.9.1.6 changelog

+ The tool is capable now to retrieve foreign keys from SQLite databases.
= Embedded SQLite functions are supported now by Visual Query Builder.
- Some access violation and other errors are fixed.
- Some memory leaks are eliminated.
- Few minor bugs are fixed.

April 09, 2011

FlySpeed SQL Query 2.9.1.5 changelog

+ The new "Add CTE" button is added to the query builder toolbar that allows
  to add new or insert existing CTE to the query.
+ A menu is shown now on dropping a saved query to Design Pane asking to add
  this query as Derived Table or as CTE.
+ SQL formatting options for Common Table Expressions are added.
- "Ancestor for 'SpTBXPanel1' not found"
= Notification for a possible problem with connecting to Oracle under 64-bit
  Windows versions is added. See the F.A.Q. page for details.