Release History

FlySpeed SQL Query History

July 06, 2017

3.5.4.0

+ Folding SQL scripts by statements is possible now.
- Several bugs in the filter builder have been fixed.
- Other minor bugs have been fixed.

June 23, 2017

3.5.3.0

+ The Expression Editor ellipsis button in Expression column of the Query
  Columns Grid doesn't hide the combo box button in the inline editor but
  displayed next to it.
- Large delay on opening the Expression Editor in the case of large 
  database schema has been fixed.
- The bug with incorrect loading of conditions joined with the topmost OR
  operator has been fixed.
- Minor bugs have been fixed.

June 09, 2017

3.5.2.0

+ It is possible now to connect through the SSH tunnel to a database host
  which differs from the 'localhost'.
- The bug with loading of date/time filter with BETWEEN operator on the
  Query Results tab has been fixed.
- Minor bugs in the Query Parameters Values dialog have been fixed.

June 01, 2017

3.5.1.3

- The critical bug with incorrect SQL query generation has been fixed.
= The new 100k limit of displayed records has been added.
- Loading of the SQL filter builder conditions has been fixed.
- The error on resizing SQL text editor has been fixed.
- The bug on formatting SQL text in the query window with unassigned
  database connection has been fixed.

May 26, 2017

3.5.1.2

- Oracle: The bug with retrieving fields for synonyms has been fixed.
- The bug with the query text formatting on the SQL Text tab has been fixed.
- The bug with entering values of unnamed parameters has been fixed.
- Minor bugs have been fixed.

May 23, 2017

3.5.1.1

+ Now it is possible to select PostgreSQL database from the list.
= Now it is not possible to display all records at once in the results data
  grid if fetching on demand is disabled. You can turn on this option on the
  Advanced tab of Connection Properties dialog.
- Minor bugfixes and improvements have been made.

May 19, 2017

3.5.1.0

= The popup edit box does not appear above the row now on pressing Ctrl+F
  keys in the Data Grid. Users can manage their search via the new panel
  below the grid.
= The Incremental Search button is displayed now in the Data Grid toolbar.
  It lets turn on and off moving down to the record corresponding to the
  characters you type and highlighting them.
= The new "SQL" button on the Data Grid toolbar has been added. It displays
  the currently executed SQL query text in a message box.
= Now the text of SQL query is displayed in the error message box when 
  an error occurs during the SQL query execution.
- The bug with not applying the default database name for PostgreSQL
  connections has been fixed.
- The bug with not saving the list of selected databases between work
  sessions has been fixed.
- Some bugs in the SQL filter builder have been fixed.

May 17, 2017

3.5.0.2

+ Now it's possible to add new detail view from the cell popup menu for
  fields with a foreign key constraint.
+ The tool now prompts if the SQL file opened from Explorer is already 
  edited. The user can choose to save edits to another file, to discard
  changes and reopen the file or to continue editing.
- The bug with applying Database property for different connection types
  has been fixed.
- Retrieving the list of databases for MS SQL Server and MySQL has been
  fixed.
- Detail views are closed automatically now if a corresponding field is
  missing in the query results.
- Minor improvements and bug fixes have been made.

May 04, 2017

3.5.0.1

- The bug with adding new connections has been fixed.
+ ODBC, DB2 connection types: The new option "Fetch records on demand" 
  has been added to the Advanced tab of Connection Properties dialog.
= DB2: The "ODBC Driver" option has been moved to the main tab of 
  Connection Properties dialog. Note that this option is global and needs
  program restart to be applied.
- Other minor bug fixes and improvements have been made.

May 02, 2017

3.5.0.0

= Now it is possible to cancel loading the list of databases from server 
  in the Connection Properties dialog and Create New Connection wizard.
- The bug with scrolling the text editor using scroll bars has been fixed.
- The bug with the cursor not aligning with the last line being edited
  has been fixed.
- MS SQL Server: The bug with setting table lock on the server while
  browsing the data has been fixed. Now data has been completely loaded to
  the grid. Users can limit the number of loaded records using the combo
  box on the toolbar and on the Advanced tab of Connection Properties.
  If you want to get back to the previous behavior, set the "Fetch records
  on demand" option on the Advanced tab of Connection Properties.
- Loading metadata from DB2 iSeries has been improved.
- Minor bug fixes have been made.