FlySpeed SQL Query

Release History

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.

April 01, 2011

FlySpeed SQL Query 2.9.1.3 changelog

- Bug with converting double backslashes to single in Portable mode is fixed.
= more reliable rare errors handling is made.

March 26, 2011

FlySpeed SQL Query 2.9.1.2 changelog

+ The "Same as Main Query format" option is added to the SQL text formatting 
  options of Expression Sub-queries and Derived Tables.
+ "Maximim object height" option is added to the Query Builder visual options.
+ Now the tool saves the height of SQL text editor and the height of Query
  Columns Grid automatically.

March 23, 2011

FlySpeed SQL Query 2.9.1.1 changelog

+ ODBC connection form is updated: 
  * "Launch ODBC Administrator" and "Create new ODBC DataSource" buttons;
  * Connection Timeout and Command Timeout are moved to additional props;
  * Username and Password can be saved now in connection properties.
+ Moving connection queries on changing Global queries path is made.
= Ability to cancel moving queries to a new location is made.
= The Global Query Path is stored relatively now if set to default folder or
  it's sub-folders.
= The "Set to default folder" button is added to the Options dialog.
= On changing the Portable mode setting the user is asked to move the Saved
  queries to appropriate location.
= Execution of SELECT statements only is allowed in Read-only mode.
= MS Access and MySQL Login Prompt dialogs are back.
- The bug with incorrect creation of sub-folder in the queries folder is fixed.
- Unnecessary query builder update on executing SQL Query is removed.
- Memo fields were not exported to OpenXML format. Fixed now.
- Timestamp fields export to MS Excel error is fixed.
- Passwords were saved in connection properties despite of the "Save password" 
  setting. Fixed now.

March 14, 2011

FlySpeed SQL Query 2.9.1 changelog

+ Export to Open XML spreadsheet is made.
= Showing the error instead of creating new database is made on trying to open 
  unexisting SQLite database file.
= Ability to hide Data Grid columns is restored.
= Export data formats can be set in the Data Export - Data Formats dialog only.
= Shift key is processed in Save Changes dialog is processed on closing the
  whole application only.
= File errors are shown as messages, not as exceptions now.
= Creating queries with invalid characters is forbidden.

March 12, 2011

FlySpeed SQL Query 2.9.0.6 changelog

+ The new button to Re-Format SQL Query text is added to the toolbar.
= Switching between SELECT and other types of statements goes without asking now.
- The bug with not saving MS SQL Server name to connection settings is fixed.

March 09, 2011

FlySpeed SQL Query 2.9.0.5 changelog

- The bug with incorrect setting of the Query Changed flag is fixed now.

March 05, 2011

FlySpeed SQL Query 2.9.0.4 changelog

- The bug with copying WideMemo fields to clipboard is fixed.
- The bug with incorrect SQL generation of Oracle objects from DB links is fixed.