FlySpeed SQL Query

Release History

August 04, 2014

FlySpeed SQL Query 3.0.1.1 changelog

- The "Provider cannot be found" is fixed.
- MS SQL Server: Native Client 11 connection strings are fixed.

August 01, 2014

FlySpeed SQL Query 3.0.1.0 changelog

+ The "Autofit columns width" button is added to the Data grid toolbar.
+ The new properties to control behavior on double-click on database objects
  and saved queries in the Database Explorer are added.
+ The new property to control sorting of fields in datasources on Design area
  of the Query Builder is added.
+ The new property to control docking of the Query window toolbar to the 
  main window is added.
+ Drag-n-drop of objects, fields and saved queries to the SQL text editor
  is possible now.
+ Schema name is skipped now when database objects are grouped by schema in 
  the Database Explorer tree.
+ Query windows toolbar is improved. 
= Adjusting control's height in the Query Builder tab on decreasing Query
  window height is made now.
- Exporting Time values to .xls Excel file is fixed.
- Setting of column widths when exporting to Excel is corrected.
- The bug with not opening the master password prompt is fixed.
= Japaneese language is updated.
- Displaying XML and GIF files in BLOB view is corrected.
- Advanced cconnect options to group objects by schema and type are fixed.
- Date formats are fixed in Report view.
- Errors on trying to get access to inaccessible folders of queries saved 
  in connection are handled correctly now.
- Many other minor fixes and improvements are made.

July 04, 2014

FlySpeed SQL Query 3.0.0.3 changelog

+ The new options to group objects in the database explorer by schema
  and object type, to hide system objects, and to expand grouping nodes
  automatically are added to the advanced connection properties.
- The bug with not expanding table fields in the database objects tree 
  is fixed.
- The bug with not updating columns orders in the data grid on changing 
  it in the query is fixed.
- The error on executing non-SELECT statement is corrected.
- The bug with incorrect setting of date separator in the data grid is 
  fixed.
- Other minor bugs are fixed. 
= Language files are updated; unused items are removed. 

June 12, 2014

FlySpeed SQL Query 3.0.0.2 changelog

+ New database password prompt dialog is made.
- All types of connections work correcly now.
- Information about foreign keys is loaded correctly.
= Connection to SQLite is possible in mormal (not exclusive) mode only.

June 10, 2014

FlySpeed SQL Query 3.0.0.1 changelog

- Execution of non-SELECT statements is possible now.
- Prompting for password for MySQL connections is fixed.
- Editing data in MySQL is fixed.
---------------------------------
! Known problems of this Beta version:
- Some connection types configured to prompt for password are still unworkable.
- Information about foreign keys is not loaded correctly. Thus, lookup data is
  now shown, joins are not created automatically, the Add linked objects menu
  is not working.
* You can download the latest version of 2.10 branch here:
  http://www.activedbsoft.com/files/sqlquerytool-2.10.1.8.exe

June 09, 2014

FlySpeed SQL Query 3.0.0.0 changelog

! This is the first public 3.0 beta version. 
+ Query Layout and SQL History are saved between work sessions now.
+ Table data can be browsed and edited without building a query.
+ Multiple records deletion is possible now.
+ Copying and pasting single cell data without entering into the cell data 
  edit mode.
- The problem on opening a query before the metadata is completely loaded is
  fixed now.
- Query cancellation is funcioning properly in all the cases now.
- Timestamp and Date parameters are fixed.
- Other minor bugfixes and improvements are made.

March 25, 2014

FlySpeed SQL Query 2.10.1.8 changelog

+ "Charset" option to connect to non-Unicode MySQL databases is added to the
  Advanced tab. Turn off the "Use Unicode" option to take effect of this one.
= Local port for SSH connections is determined automatically now.
- ANSI standard DATETIME'dd/mm/yyyy' literals are supported now.
- Other minor fixes are made.

March 19, 2014

FlySpeed SQL Query 2.10.1.7 changelog

+ SQLite: User is prompted now to create a new database if database file 
  does not exist.
+ SQLite: Now it's possible to select exclusive or shared locking mode.
- Advantage DB: Support of Left/Right and other built-in functions is made.
- FoxPro (*.DBF files) connections: Result data is editable now.
- FoxPro: Records marked as deleted are hidden now.
= MySQL: Setting Connection timeout option to zero means timeout disabling.
- MySQL: Incorrect setting of SSH port is fixed. 
- InterBase/Firebird: Creation of new connection with default user password 
  ('masterkey') is fixed now.
= Data export core is updated.
 

January 25, 2014

FlySpeed SQL Query 2.10.1.6 changelog

- The bug with prolongation of portable version is fixed.
- Minor fixes in PostgreSQL, Firebird and MySQL syntax parsers are made.
- Other minor fixes are made.

December 25, 2013

FlySpeed SQL Query 2.10.1.5 changelog

! Merry Christmas ! :)
- Adding object to the query by double clicking or dragging from the 
  database schema tree is performed correctly and does not cause any 
  errors now.
- Other minor bug fixes and SQL syntax improvements are made.