| Author | 
		Message | 
	
	
		
			SysOp 
			Site Admin 
			
  
			
			
				Joined: 26 Nov 2006 Posts: 7992
  | 
			 
			  
		 | 
		
			
				  SQL Assistant v3.0 beta program is now CLOSED | 
				     | 
			 
			
				You can download the beta version here
 
http://www.softtreetech.com/sqlassist/
 
  Last edited by SysOp on Mon Jan 07, 2008 1:25 pm; edited 4 times in total | 
			 
		  | 
	
	
		| Mon Nov 12, 2007 4:37 am | 
		          | 
	
	
		  | 
	
	
		
			hitesh 
			 
			
  
			
			
				Joined: 15 Oct 2007 Posts: 104
  | 
			 
			  
		 | 
		
			
				   | 
				     | 
			 
			
				What's new in ver SQL ASSISTANT 3.0 ?
  | 
			 
		  | 
	
	
		| Mon Nov 12, 2007 4:49 am | 
		          | 
	
	
		  | 
	
	
		
			SysOp 
			Site Admin 
			
  
			
			
				Joined: 26 Nov 2006 Posts: 7992
  | 
			 
			  
		 | 
		
			
				   | 
				     | 
			 
			
				Here is a list of main changes. More detailed information will be posted in a couple of days.
 
 
----------------------------------
 
1.	Context SQL suggestions based on the typing history.
 
2.	Matching brackets highlighting 
 
3.	Statement matching beginning/closing highlighting (BEGIN..END, IF..END IF, LOOP..END LOOP, etc...)
 
4.	One-step complete SELECT statement generation after selecting columns in SELECT prompt
 
5.	Advanced Auto indent features
 
6.	Support for help with procedure parameters in MySQL 
 
7.	Syntax checking of SQL queries in DB2 and MySQL
 
8.	Support for objects and columns declared in temp tables and table variables 
 
9.	Code expansion for * and other elements in DML statements
 
10.	Context suggestions for code expansion 
 
11.	Support for multi-column selection using check boxes
 
12.	Multiple formatting styles
 
13.	Advanced code snippets for auto-generating object-specific code fragments
 
14.	Advanced selection and code generation of variables in DECLARE statements
 
15.	Improved popup activation after dot or bracket
 
16.	Auto-generation of table aliases 
 
17.	Support for MySQL native client connections
 
18.	MySQL Query Browser Connect Interception 
 
19.	Advanced code expansion in DML statements
 
20.	IntelliSense list content filtering control added to Options
 
21.	Context sensitive help with DDL commands
 
22.	Improved Code formatting - Control of bracket positioning 
 
23.	Built-in addons for SSMS, VS, VS for Database Team Professionals (former Data Dude)
 
24.	Support for Toad for MySQL/DB2/SQL Server
 
25.	Expiremental support for Sybase databases
 
----------------------------------
 
 
 
I am sure this list will satisfy most people.
  | 
			 
		  | 
	
	
		| Mon Nov 12, 2007 9:31 am | 
		          | 
	
	
		  | 
	
	
		
			TDarnall 
			 
			
  
			
			
				Joined: 13 Nov 2007 Posts: 7 Country: United States | 
			 
			  
		 | 
		
			
				  BETA Support procedures | 
				     | 
			 
			
				I have just downloaded and installed the 3.0 Beta, and would like to begin my submission of bugs/enhancement requests. Where/how should i go about doing so?
  | 
			 
		  | 
	
	
		| Tue Nov 13, 2007 9:21 am | 
		          | 
	
	
		  | 
	
	
		
			SysOp 
			Site Admin 
			
  
			
			
				Joined: 26 Nov 2006 Posts: 7992
  | 
			 
			  
		 | 
		
			
				   | 
				     | 
			 
			
				Thanks for trying SQL  Assistant. 
 
 
Please report all issues in this forum. This is the right place.
  | 
			 
		  | 
	
	
		| Tue Nov 13, 2007 10:23 am | 
		          | 
	
	
		  | 
	
	
		
			TDarnall 
			 
			
  
			
			
				Joined: 13 Nov 2007 Posts: 7 Country: United States | 
			 
			  
		 | 
		
			
				   | 
				     | 
			 
			
				As stated, i just installed today. Everything appears to be working well, except that in the drop down candidate list, it only shows the available Databases and built-infunctions.
 
I have set the options in SqlAssistant to *not* show the Databases, but it still only shows the 2 object types and nothing else.
 
 
As a note, i also have RedGate SQL Prompt installed, but disabled. I am using MS Management Studio connection to SQL 2005 DB.
  | 
			 
		  | 
	
	
		| Tue Nov 13, 2007 11:32 am | 
		          | 
	
	
		  | 
	
	
		
			SysOp 
			Site Admin 
			
  
			
			
				Joined: 26 Nov 2006 Posts: 7992
  | 
			 
			  
		 | 
		
			
				   | 
				     | 
			 
			
				Please post this message as a new topic and attach a small screenshot demonstrating the settings as you have them selected and what you get on the screen, the popup area and part of the SQL command in which it is invoked, the location is important.
 
 
Please do not post to this generic "announcement" topic, which cannot be used for the issue tracking purposes.
  | 
			 
		  | 
	
	
		| Tue Nov 13, 2007 11:47 am | 
		          | 
	
	
		  | 
	
	
		
			SysOp 
			Site Admin 
			
  
			
			
				Joined: 26 Nov 2006 Posts: 7992
  | 
			 
			  
		 | 
		
			
				  The beta program is now closed | 
				     | 
			 
			
				Thank you all who participated in the beta testing. The beta testing is now CLOSED. 
 
 
SQL Assistant v3.0 retail version will be released shortly. Stay tuned.
  | 
			 
		  | 
	
	
		| Wed Dec 05, 2007 10:53 am | 
		          | 
	
	
		  | 
	
	
		 |