Last edited by SysOp on Thu Dec 06, 2007 11:33 am; edited 1 time in total

Thu Apr 19, 2007 1:51 am

SysOpSite Admin

Joined: 26 Nov 2006Posts: 6579

Cumulative build #12 and #13 (April 23, 2007) - here are the changes:

1. Multiple fixes for previously reported bugs
2. Reworked Code Structure View - now it is possible to edit code and use the code navigation at the same time.
3. Better integration between DB Tools and SQL Assistant. Starting with DB Tools 5.0.4.122 and SQL Assistant 2.0.13 the database connection can be shared and no additional connection prompts are required.
4. Code syntax check options expanded to multiple editors.
5. SQL Reference for MySQL has been updated to support new features in MySQL 5.1 including events, partitioning, etc...
6. Incremental enhancements in the code beautifier tool

Tue Apr 24, 2007 8:48 am

SysOpSite Admin

Joined: 26 Nov 2006Posts: 6579

Build #2.0.16 has been released on May 7. This build fixes the following issues

1. In DB2 catalog queries TRIM function replaced with RTRIM in order to support DB2 versions 7 and 8
2. SQL Assistant stops working after hitting object or column name matching one of the SQL keywords
3. On Windows shutdown, SQL Assistant doesn't always terminate and sometimes the process has to be killed forcedly
4. Intellesence popups for table function parameters in T-SQL show parameter shifted by 1 position
5. Unhandled exception at 0x08089542 in mmc.exe: 0xC0000005: Access violation reading location 0x01a0a960.

Quote:

ATTENTION:

As of build 2.0.16 the beta program for version 2.0 is over. Thank you all who have downloaded and tried it. Especially thank you everybody who provided bug reports, and expressed thoughts for future development directions and told us where we need to focus.

If you are one of them, please don't hesitate to request your free SQL Assistant license. Email your forum user name and registered email to our sales team. Please note that the license is going to be sent to your registered forum email. The license also includes full year of free maintenance and support.

We will continue fixing bugs in version 2.0 (if any are found) but will not add any new major features until the next maintenance release, which is planned for 3rd quarter 2007. The roadmap for version 2.x and beyond will be published in a separate message. Please feel free to send us your ideas and suggestions for what we can improve or add to the product and what can help you in your everyday SQL coding and database administration tasks. The SQL Assistant 2.x to-do list is wide open for new additions. Please also feel free to post useful code snippets that we can add to the default SQL Assistant code snippet collection. Your feedback is always greatly appreciated.

Announcement: Version 2.5 will be released soon as a free upgrade to all v2.0 registered users

Tue Jun 26, 2007 11:01 pm

SysOpSite Admin

Joined: 26 Nov 2006Posts: 6579

Hi everybody,

Version 2.5 has finally arrived and available for download. It is available as a free upgrade for all registered version 2.0 users.

Here is what's new in this version:
1. New one-click Procedural Code View - with a single click you can lookup and browse code of referenced procedures, functions, packages or just type the name and click it – forget your old database browsers.
2. New integrated spell checker for SQL code comments and hard-coded string
3. Improvements in Code Formatter and Beautifier
4. Smarter IntelliSense in the code auto-completion features
5. Enhancements in the Code Structure View - added support for loops and conditional statements, support for more types of SQL commands
6. Added support for more SQL editors and IDEs
7. Significant improvements made in the Options making it easier than ever to customize SQL Assistant behavior.
8. other minor improvements over version 2.0

Thu Jul 05, 2007 1:51 pm

SysOpSite Admin

Joined: 26 Nov 2006Posts: 6579

Build #2.5.12 is now available.

This build fixes several anomalies found when running SQL Assistant on Windows Vista including issues with code snippets, "ImageList" errors, registered versions not working in MS Query Analyzer and in Notepad and several other annoyances.

If you are not using Vista you can skip this release, otherwise we highly recommend upgrading to 2.5.12 as soon as possible.

Fri Jul 13, 2007 11:13 am

SysOpSite Admin

Joined: 26 Nov 2006Posts: 6579

Build #2.5.14 is now available.

The main change in this build is conversion of the configuration file format from CFG to SAS. The main reason for that change is Vista poorly designed mechanism to virtualize access to all configuration files. Basically Vista is copying configuration file data to the registry without being asked for that and later substituting normal reads from config files with reads from the registry, which in turn makes Vista frequently return bad or outdated data breaking normal SQL Assistant workflow and created unneeded anomalies.

Other issues resolved in this build:
1. Invalid procedure parameters displayed in parameters popups when working with SQL Server and the user is not dbo but whose default schema is set to dbo.
2. Duplicate object names appearing in object name popups when using the forced auto-completion feature.
3. "Change All" function incorrect behavior in the code spell checker.
4. SQL Assistant stops displaying popups after working with large T-SQL files for a long time.

Wed Aug 08, 2007 3:32 pm

SysOpSite Admin

Joined: 26 Nov 2006Posts: 6579

Build #2.5.20 released on August 26.

Builds 2.5.15, 2.5.17, 2.5.18, 2.5.19 contained mostly internal changes and were never released. Build 2.5.16 contained both bug fixes and internal changes, including changes related to dealing with Vista backward incompatible changes in registry and configuration file virtualization. Here is a cumulative list of major changes and fixes in all builds from 2.5.15 to 2.5.20:

1. Native add-in component added for SQL Server Management Studio and Management Studio Express. If the add-in is registered with the target, it is not necessary anymore to run SQL Assistant as an icon in the system tray and have it watch for new processes, because the Management Studio will load it automatically on startup.
2. Native add-in component added for Visual Studio and Management Studio Express, including full menu integration. If the add-in is registered with the target, it is not necessary anymore to run SQL Assistant as an icon in the system tray and have it watch for new processes, because the Visual Studio will load it automatically on startup.
3. Fixed issue with targets crashing after SQL Assistant Options modified several times while some targets are open.
4. For SQL Server targets, when pasting user-function name, schema name is pasted automatically as part of the name
5. Fixed behavior of assistance for TRUNCATE TABLE
6. For MySQL targets added BEGIN keyword
7. Syntax check now displays a confirmation message if no errors found during the check
8. Fixed function parameter prompts for nested functions
9. Fixed SQL Assistant crashing if spell check is invoked on a system without MS Word installed.
10. Implemented enhanced version of the automatic indent feature. Starting with build 2.5.20 auto-indent works for both opening elements of a SQL construct and closing elsements,, for example, pressing Enter key after BEGIN will cause the next line to start with additional indent, pressing Enter key after END will cause END to have the same indent as the matching BEGIN. Similar rules are created for IF..ELSE…END IF, loops, and other logical SQL statements.

Sun Aug 26, 2007 10:45 pm

SysOpSite Admin

Joined: 26 Nov 2006Posts: 6579

Announcement: SQL Assistant v3.0 beta is going to be released in the beginning of November... tons of new features. Please stay tuned.