10:th of December 2006 minor-version of Sui available (0.64D)

- Row-Filter improved to support more data types

- A couple of icons changed in the query pop-up

3:rd of December 2006 New version of Sui available (0.64C)

- Draw query builder improvements

· Group by functionality added

· Possibility to reset/set all selected columns

- Extended Export functionality

- Generation of Insert statements based on a query introduced

- Export to Microsoft Access introduced as a plugin

- A number of user interface improvements

· Font size changed for static text in query-window

· A number of icons changed

· Icons added to favorite query pop-up

· Minor restructuring of toolbars.

· Exec to Excel added to toolbar

· Icons added to query window pop-up

· Icons added to favorite toolbar pop-up

· Changed intial size of Sui at startup

- FormatSQL Improved

- Export to CSV and Export to Excel (from query window) writes the files to the

specified data-directory rather then the installation directory

- Confirmation dialogue added when attempting to save a query to an existing File

- Additional datatypes added to the filter function.

- OK buttons added to JDBC preferences and Sui properties

Bugs-fixed

----------

- Parameter values (substitution) are now kept within the session

- Cursor position in query kept after execution

- A couple of bugs related to Find and replace fixed

- Error messages if connection fails more consistent

- Fixed so that Sui finds resources in the jar file, even if the Jar file

dont exists in the current direcotory (as long as the jar file exists in

the classpath).

6:th of March 2005

New version of Sui available (0.63B)

Version 0.63B

Continued Improvements of Excel interface

A specific sheet with meta data is automatically created for the exported result set (continuing SQL-statement, Connection information etc)
Export to Excel from the Query window and from the report window are functionally aligned.

First version of Query builder introduced

The query builder lets you build simple sql-queries by adding selection and order by criteria.

29:th of February 2004

New version of Sui available (0.61B)

Version 0.61 is very much focused on an improved interface to Microsoft Excel (and other tools that can access files in XLS format). It also includes a number of other usability improvements.

Query and Excel improvements

Support for exporting data to an XLS format file from the report window added.
Context menu added on the query window (right click on the query window)
Support for “batch” execution of queries added. This type of queries are writing the result of the query directly to a file rather then presenting the result in the query window. The file type can be CSV or XLS. These types of queries are invoked from the query context menu.
Automatic launch of Excel (or another program that understands XLS files) when the batch execution to a XLS file is completed (controlled by the new preferences under the export preferences tab).

Misc changes

Query window user interface improved. The message area removed from the query window (all messages displayed as pop-ups).
Support for “scrolling” on detailed level added (List Row and F7 / F8 to scroll down and up in the result-set on a detailed level).
Preferences redesigned to a tabbed panel.
Support for adding class paths dynamically added (Sui preferences-> Class path)
Sui’s launcher program improved. You are now able to change the ini file using a GUI.

15:th of December 2003

New version of Sui available (0.60B)

Application concept re-introduced. (The application concept will be further used and documented in later versions).

3:rd of October 2003

New version of Sui available (0.59C)

Version 0.59 became a more extensive version then planned. The major new functionality feature is the introduction of support for stored procedures (callable statements). It also contains enhancements to the filter function improved printing support and a number of minor usability changes.

Sui 0.59C change list:

SP Support

Draw-Sp function (Enter SP and build a call statement using the escape syntax)
Support for execution of a SP from the procedure list
The user is prompted for SP Input-variables (IN and IN/OUT) using symbolic variable resolution (automatically drawn)
Output-variables (OUT/IN-OUT) presented as a report window with two columns; variable name + value
Results-sets from SP’s are presented in a report-window (one for each result set)
Note: There are still a number of limitations to the SP support. It only supports SP’s with Character, Varchar, Integer, Smallint, Bigint, Tinyint, date, time and timestamp parameters.

Filter support

IN and NOT IN operator added (values separated by comma)
IS NULL and IS NOT NULL operator added
Character or Varchar fields with a length up to 500 bytes can be filtered

Misc. changes

Default CSV delimiter character changed from semi colon to comma (“;” -> “,”)
The maximum number of favorite queries extended from 10 to 35.
Null value are changed from “?” to null string (“?”->””) in the exported CSV file
Error message is now displayed in pop-ups rather then in query window
Confirmations dialogues added when replacing and deleting existing favorites
Setting of java path explained in documentation and described in error messages
The content of the Query list-box is changed. When a subset of a query is executed the executed SQL rather then the entire content of the query-window is added.

Solved bugs

The parsing of SQL statements is rewritten. This solves the problem with statement delimiters (normally semi colon) enclosed by quotation marks
The Look and feel property is kept between sessions
The draw function now fully supports table names with catalogue, schema and table name.
Naming conventions for SuiSys.pro changed to conform with Linux and Unix
Bug in save query resolved
Favorite queries saved to disk when changed rather when exiting Sui.

21:st of November 2002

New version of Sui available (0.58B)

Sui 0.58 is a major version. We have added one new major feature, favorite query toolbar. We have also made significant improvements to the list table function and to the query report filter function. We have also made a number of changes to make the user interface and the documentation more consistent.

Sui 0.58B change list:

Favorite query toolbar added

A new concept to manage queries added. This function lets you add your favorite queries to a toolbar (as a toolbar icon). From the toolbar the user can execute the query and also add a description to the query.

Significant improvements to the filter function

Filter function supported for more data-types
More operators added for filtering (=, <>, < ,>, Not Like, Between)

Improvements to list table and list procedure

Possible to filter tables based on table type
List table now works for the ODBC/JDBC drivers
Bug solved related to list table and lower case
Bug solved to make sure list table works for DBMS with a catalog as part of the table name
Catalog is not included in the filter panel for DBMS without a catalog as part the table name
New option to enable that all available schemas are displayed in a combo-box on the table / Procedure panel
List of Access to tables and list of referential integrity added to table listing panel

Changes to user documentation

The user guide is re-structured and we have changed it from html to pdf.

Misc. changes

Re-design of a number of icons.
The show-SQL panel (from the query window) changed to a scrollable panel
New option to make the column width more intelligent
The size of the report list are initially set wider

6:th of November 2002

New minor version of Sui available (0.57C)

Sui 0.57C change list:

A number of bugs fixed

Filter function corrected to work correctly for filters without a % sign.
It's now possible to filter the second column of the connection details
Connection properties is now written to file when the apply button is pressed (rather then when application is closed)

Minor changes

URL added to report window title
URL added to query monitor
Max row field is validated for numeric content.
Userid and password is remembered during a session. If a user tries to connect to the same URL as before (during the same session) the userid and password from the previous connect is automatically entered in the userid and password field (happens when focus is moved from the URL-Box).

30:th of October 2002

New version of Sui available (0.57)

Sui 0.57 change list:

Filter functionality added to the query report

Filtering a query makes it possible to reduce the number of rows in the report. The report is filtered by using wild-card characters. This version supports filtering for character fields (limited to fields with a length less then 250 bytes).

FormatSQL Improved

The format SQL function is continued be improved. In this version support for Insert, Update and Delete SQL is added. Support for more complex SQL SELECT syntax is also added (Common table expressions for example). You can also format a subset of the SQL statement (select the SQL you want to format and press the formatSQL button)

Support for changing Java " look and feel"

Select edit->preferences->Look and Feel to change the look and feel of the user interface

Minor corrections

Pop-up menu placement bug solved
Possible to deselect variable substitution (Edit->Preferences)
Keep connection removed from the preference menu

The web-site now includes specific information for Oracle

28:th of August 2002

New version of Sui available (0.56)

Sui 0.56 includes new functionality for:

Change and replace of data in the query window added
A number of minor bugs fixed.

The web site now includes specific information for DB2,

11:th of November 2001

Changes to packaging and documentation

Sui changed from shareware to FREEWARE
Sui Windows installation improved. Under Windows Sui installation is done thru an installer software, supporting install and un-install of Sui
Sui documentation and web-site improved and extended

7:th of November 2001

New version of Sui available (0.55)

Sui 0.55 includes new functionality in the following areas:

Query formatting: Sui now includes support for formatting SQL Select queries. This is ideal for people working with SQL generated from tools and from other users. The formatted SQL is very easy to read.
Confirm update. Before committing changes to the database Sui asks the user to confirm the changes
Prompted queries. Sui now supports prompted queries. Sui asks the user to fill in the values for all variables in the SQL starting with a &. Before the query is executed the variable is replaced with the value entered by the user
Improved connection management. The logic for managing connection is improved. From a user perspective full support for executing parallel queries is implemented. Sui also reduces database lock contention to a minimum.

15:th of September 2001

Initial Version available (0.54)

The first generally available version of Sui is announced. www.sui.nu