SQL Assistant version 4.7 has been released

SQL Assistant build 4.7.11 is now available for download

New features and enhancements

1. Scripting table data in multi-database formats.
2. Ability to cancel running queries. without closing SQL Editor/IDE.
3. New macros for supporting table key columns in code snippets.
4. Smart use of Home and End keys and highlighting of trailing spaces.
5. Intellisense support for SQL Server 2008 MERGE statement.
6. Compatibility changes for supporting latest versions of UltraEdit and PL/SQL Developer.
7. New pre-configured target for Notepad++ editor.
8. Support for team development and sharing of settings, macros, formatting rules, etc – new Options Import/Export graphical and command line interfaces.
9. Other minor enhancements and usability changes.

Bug fixes:

1. Handling of multiple columns in CREATE TABLE statement in SQL Reference
2. Syntax check indicator bar doesn't appear in Microsoft SQL Query Analyzer
3. Incorrect keyword suggestions after comma in CREATE TABLE statement
4. Text not always inserted correctly when selecting columns using keyboard and checkboxes in popup lists
5. "Always fully qualify object names" option conflicts with Intellisense for table variables – extra text inserted before @ sign.
6. Intellisense stops working after encountering '*/' inside comments
7. Syntax checker crashes SQL Assistant and target editor when working with SQL Server over slow connection
8. Erroneous ORA-06550 error reported –encountered the symbol "." ... during syntax checking when fully qualifying object names
9. T-SQL Code parsing bug when last line in the code ends with -- style comments
10. Incorrect error highlighting when working with large SQL files
11. Mouse-over hints for tables and stored procedures/functions. not working in some windows of VS-based targets.
12. In MySQL Query Browser pressing Escape key with SQL Assistant popup active leads to Escape key being passed to the editor, in turn causing the current code to clear.
13. SQL Assistant Options dialog transparency problems.
14. Schema level-expansion and use of Backspace key lead to incorrect object list filtering.
15. Incorrect code parsing during syntax check in Oracle
16. Database context not maintained during code execution in SQL Server Management Studio when database context is switched in a middle of code.
17. JOIN suggestions for column name matches offered only for a single table in the FROM clause, other tables ignored.
18. Double alias inserted after column selection after use of forced popup (Ctrl+Space)
19. Warning about currently selected OCI.DLL appears repeatedly when using SQL Assistant with PL/SQL Developer.
20. Query results cannot be saved from data preview pane for long text queries – full query text is used as a suggestion for output file name and breaks if the suggested name is over 255 characters long.

Here is a link to the previous version info http://www.softtreetech.com/support/phpBB2/viewtopic.php?t=22777

Last edited by SysOp on Wed Oct 14, 2009 10:53 pm; edited 1 time in total

This is a Great Stuff of Good Work!

Keep going...

Many thanks for your kind words. We are glad to hear that you loved the improvement made in this maintenance release. Our team is working very hard every day on improving the product.

Sysop