SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
SQL Assistant 3.1 is now available
Goto page 1, 2  Next
 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
SQL Assistant 3.1 is now available
Author Message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post SQL Assistant 3.1 is now available Reply with quote
This new maintenance release is currently available as a private build that can be downloaded by invitation only.

Here is a brief list of new features and enhancements
• Table data mini-preview (single-click on a table, view, or synonym shows first 100 records)
• Direct code execution – HORAY!!! Notepad and other simple editors can now fully compete with specialized SQL editors and development environments.
• Support for MS Access as a back-end database, via direct integration with Access IDE and via ODBC database connection from other SQL editors (for example, you can now run MS Access queries and make data changes from Notepad)
• SQL Code Structure support for CALL statements and other enhancements in the Structure view
• DB2 and MySQL – support for FOR NOT FOUND and CURSOR..FOR constructs
• Connection interception for SSMS in SQL Server 2008 (Katmai)
• Add-on registration for SSMS in SQL Server 2008 (Katmai)
• Branch expansion in popups and enhanced multi-level item filtering in expanded branches.
• Full support for synonyms in SQL 2005/2008
• New options to qualify object names.
• Formatting code enhancements – added support for code structures beginning with the same keyword, for example, BEGIN and BEGIN TRY


Last edited by SysOp on Thu Oct 02, 2008 2:49 pm; edited 2 times in total
Fri Jan 25, 2008 4:58 pm View user's profile Send private message
seth.rothman



Joined: 29 Jan 2008
Posts: 54
Country: United States

Post 3.1 Reply with quote
How does one get a copy of this release?
Tue Jan 29, 2008 4:14 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Reply with quote
Just email a request to the support account and indicate your current license number as a proof of your license.
Tue Jan 29, 2008 4:19 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Reply with quote
Thanks. I can reproduce it now. It only behaves this way if table goes first and view goes second. I will submit this info to the development team. Hope it is simple to fix.
Tue Jan 29, 2008 4:51 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Reply with quote
This issue has been fixed in 3.1.12
Wed Jan 30, 2008 10:53 pm View user's profile Send private message
ssandu



Joined: 26 Feb 2007
Posts: 95
Country: Romania

Post Another posible issue Reply with quote
When I try to add an WHEN clause after an enter on a SELECT DISTINCT or SELECT * the WHERE clause goes 2-3 TABS on left.
This is not happening on a SELECT with fields.
I've attached some screen shots to illustrate this.
It's not affecting the sql but it's not looking fine :)
Windows Vista, SQL Server 2005, SQL Assistant 3.1.12





Hope this helps.
Sorin
Thu Feb 14, 2008 3:22 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Reply with quote
Thanks for the feedback.

This is a known issue in 3.1.0x which we fixed in most recent development builds. The auto-format as you type code feature makes WHERE keyword automatically align with the FROM keyword part instead of SELECT. If you start FROM on a new line then the result looks good but if you leave it on a previous line, then it doesn't look good. The scope is not limited to WHERE. It uses previous keyword to calculate the required indent, instead of the first keyword in the statement.

The fix should be available in a public 3.1 release.
Thu Feb 14, 2008 8:29 am View user's profile Send private message
ssandu



Joined: 26 Feb 2007
Posts: 95
Country: Romania

Post Reply with quote
Are any new development builds ?
This issue makes me crazy :))
Thank's
Tue Feb 19, 2008 11:17 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Reply with quote
we'll send you an email with the download link
Tue Feb 19, 2008 11:50 am View user's profile Send private message
ssandu



Joined: 26 Feb 2007
Posts: 95
Country: Romania

Post Reply with quote
Thank's
I've got it.
But now SQL Assistant can't connect to my SQL Server(I saw you've changed the Connect dialog box).
I can't select a server from dropdown list (when I select a server it goes to the database field).
Even write manual them and try both ODBC and ASP.NET connections gave's me an error of wrong connection string.
So I've installed again 3.1.12.
Hope this helps with development.
Sorin
Wed Feb 20, 2008 5:34 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Reply with quote
Hi,

I'm not sure how you are connecting and from which editor. Yes, the internal connection handling is very different now as we are adding more flexibility to it and allowing generic support for ODBC-based and ADO.NET-based connections, basically allowing to choose any driver to handle the connection and customize some other parameters, such as connect and command timeouts.

Yet, if you are using one of default editor targets, the connection should be intercepted and shared with the editor without a need to enter/configure it manually.

Please create a separate topic with details about the non-working connection and I'll try to help you enter the correct parameters.

Thanks
Wed Feb 20, 2008 11:50 am View user's profile Send private message
hitesh



Joined: 15 Oct 2007
Posts: 104

Post Release Date Reply with quote
Do you have any projected tentative release date for this new ver?
Thu Feb 21, 2008 7:09 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Reply with quote
Monday, next week.
Thu Feb 21, 2008 11:19 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Reply with quote
The latest version build 3.1.18 is now publicly available and can be downloaded here http://www.softtreetech.com/isql.htm

• Direct code execution – Notepad and all other simple editors can now fully compete with specialized SQL editors and development environments.
• Table data mini-preview (single-click on a table, view, or synonym shows first 100 records)
• Support for MS Access as a back-end database, via direct integration with Access IDE and via ODBC database connection from other SQL editors (for example, you can now run MS Access queries and make data changes from Notepad).
• Data export to Excel and text files.
• SQL Code Structure support for CALL statements and other enhancements in the Structure view.
• DB2 and MySQL – support for FOR NOT FOUND and CURSOR..FOR constructs.
• Connection interception for SSMS in SQL Server 2008 (Katmai).
• Add-on registration for SSMS in SQL Server 2008 (Katmai)
• Branch expansion in popups and enhanced multi-level item filtering in expanded branches.
• Full support for synonyms in SQL 2005/2008
• New options to fully or partially qualify object names.
• Formatting code enhancements – added support for code structures beginning with the same keyword, for example, BEGIN and BEGIN TRY
• Logical join completion for subqueries - joins between tables referenced in the main query and tables referenced in subqueries.
• Support for join candidates using matching column names.
• Improved code auto-indent handling.
• Reworked and expanded database connection handling. Starting with this version ADO.NET-based and ODBC-based connections can be used with all supported database systems. For ODBC-based connections both DSN and DSN-less connections are now supported.
• Client-side authentication is now supported for DB2 and Sybase database connections using ADO.NET interfaces.
• Numerous other minor enhancements and usability changes.
Sun Feb 24, 2008 11:41 pm View user's profile Send private message
kevin83177



Joined: 18 Apr 2007
Posts: 10
Country: United States

Post Where do we download? Reply with quote
Do you have to put all the registration info in the trial area to get the v3.1?
Mon Feb 25, 2008 2:24 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Goto page 1, 2  Next
Page 1 of 2

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.