Red Gate forums :: View topic - SQL Prompt 6.3 beta (Now closed)
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Prompt 6
SQL Prompt 6 forum

SQL Prompt 6.3 beta (Now closed)

Search in SQL Prompt 6 forum
Post new topic   Reply to topic
Jump to:  
Go to page 1, 2  Next
Author Message
Aaron Law



Joined: 28 Jun 2013
Posts: 139
Location: Red Gate Software

PostPosted: Thu Jan 23, 2014 4:34 pm    Post subject: SQL Prompt 6.3 beta (Now closed) Reply with quote

Beta closed - thanks to everyone who took part!


This latest beta build of SQL Prompt includes:

New features

  • Select in Object Explorer (context menu as well as Ctrl + F12) (UserVoice)
  • Many improvements to our SQL grammar
  • UpperCamelCase & lowerCamelCase casing options
  • Highlighting matching parentheses (UserVoice)
  • Template parameter dialog box now opens automatically if a snippet has parameters (Forum post)
  • $SELECTIONSTART$ and $SELECTIONEND$ snippet placeholders (Documentation)
  • Improvements to when Prompt suggestions box is displayed (suggestions are now displayed if you continue to type a half completed word)
  • Pressing Enter after GO now enters a new line
  • Inserted and Deleted tables now suggested for triggers (and now resolve to correct table in other statements) (UserVoice)
  • String constant suggestions for SERVERPROPERTY, FILEPROPERTY, DATABASEPROPERTYEX, etc
  • Suggestions box now auto-hides when there are no suggestions
  • Partial matching system improvements (UserVoice)
  • More suggestions for new 2014 syntax
  • Show schema names button state is now saved (UserVoice and UserVoice)

New in 6.3.0.294

  • Suggestions box delay option added (UserVoice)
  • More documentation for built-in functions
  • More string literal suggestions

Feedback
If you encounter any issues with the beta, post them on this forum.

If you have any suggestions for improvements to SQL Prompt, post them on our suggestions forum.


Bug fix version history

6.3.0.252

  • Columns suggested first in search conditions (eg WHERE and HAVING) (Forum post)
  • Auto-completed functions won't insert closing parenthesis if directly before a column (eg. "SUM(Column" instead of "SUM()Column")
  • Column names on expand wildcard are no longer qualified with schema names
  • Fixes for several bugs that were sent to us as error reports from SQL Prompt

6.3.0.240

  • Improved suggestions after errors in script (Forum post)
  • Improved suggestion ordering (Forum post)
  • Minor performance improvements

6.3.0.188

  • Select in object explorer now selects objects on a connected linked server (Forum post)
  • Select in object explorer now works with table types and table-valued functions (Forum post)
  • Fix for "value" stopping suggestions (Forum post)
  • Fix for suggestions stopping (Forum post)
  • Fix for SP-4994 (Unable to load DLL 'SQLite.Interop.dll')
  • Fix for SP-3598 & SP-4984 (Very large encrypted stored procedures are not decrypted properly)

6.3.0.121

6.3.0.102

  • Auto generated insert statements now use GETDATE() instead of a string literal (UserVoice)

6.3.0.100

  • Fix for CamelCase datatypes enclosed in square brackets
  • Fix for SP-5013 (NullReferenceException)

6.3.0.95

  • Fix for xml casing (Forum post)
  • Fix for select in object explorer failing in SSMS2008R2 (SP-5006/"Field 'Microsoft.SqlServer.Management.SqlStudio.Explorer.ObjectExplorerService.hierarchies' not found.")
  • A few missing suggestions added for built in functions

6.3.0.70

  • Auto generated insert statements with hints and a semicolon will keep the hints/semicolon (Forum post)

6.3.0.66

  • Fix for missing options (eg custom aliases)

6.3.0.65

  • Fix for snippet $SELECTIONSTART$ selecting wrong text across multiple lines with indentation
  • Select in object explorer works if the cursor is on a semi-colon (Forum post)
  • Insert statements keep the table hints with the name when generating insert code (Forum post)
  • More grammar fixes

6.3.0.39

  • Fix for keywords occasionally not being recased (Forum post)
  • Fix for wrong suggestion being selected
  • Fix for ‘left’ not being cased correctly (Forum post)
  • Master database is enclosed with square brackets if the option is set
  • Various keyword casing fixes
  • Fixed the following bugs that were sent to us as error reports from SQL Prompt: SP-3556, SP-4388, SP-3680, SP-3860, SP-4258, SP-4379, SP-4192, SP-3545, SP-4948, SP-4982


Last edited by Aaron Law on Tue Apr 08, 2014 3:07 pm; edited 16 times in total
Back to top
View user's profile Send private message
PDinCA



Joined: 25 Jul 2005
Posts: 500
Location: Costa Mesa, CA, USA

PostPosted: Sat Jan 25, 2014 12:22 am    Post subject: Reply with quote

Option to turn OFF bracket-matching, please?

I find that SSMS Intellisense limited to code blocks and bracket-matching works extremely well with SQL Prompt. I wouldn't like to see the two products argue over who will highlight a bracket, or not.

Thanks.
Back to top
View user's profile Send private message
Aaron Law



Joined: 28 Jun 2013
Posts: 139
Location: Red Gate Software

PostPosted: Mon Jan 27, 2014 12:58 pm    Post subject: Reply with quote

Hi Stephen,

I don't think they argue over who gets to highlight a parenthesis, if you do notice any issues please let us know and we'll fix them.
Back to top
View user's profile Send private message
JBSandhills



Joined: 29 Jan 2014
Posts: 2

PostPosted: Wed Jan 29, 2014 12:32 am    Post subject: XML Nodes Method Reply with quote

When formatting SQL XML statement like the following with the XML method "nodes" on my computer, nodes becomes capitalized, and this capitalization causes the query to fail. Also, I noticed that formatting puts a space between the "T" and "(x)". I don't remember that happening in previous versions.

[u]It should be:[/u]
SELECT T.x.value('./@Value1', 'INT'), T.x.value('./@Value2', 'INT')
FROM @XMLVariable.nodes('RawData/RawDataRecord') AS T(x)

[u]After formatting:[/u]
SELECT T.x.value('./@Value1', 'INT'), T.x.value('./@Value2', 'INT')
FROM @XMLVariable.NODES('RawData/RawDataRecord') AS T (x)

I never had problems with the node keyword or its alias before the beta, so I think it might be a bug. Can you please have someone look into it?

Thanks.
Back to top
View user's profile Send private message
Aaron Law



Joined: 28 Jun 2013
Posts: 139
Location: Red Gate Software

PostPosted: Wed Jan 29, 2014 10:59 am    Post subject: Reply with quote

Hi JBSandhills,
Thanks for reporting this - I can recreate the "nodes" being uppercased and will look into a fix for you.

For the space between the T and the (x) I think that it might have always been like that (I just gave it a try 6.2 and 5.3). Is this something you'd want changed?
Back to top
View user's profile Send private message
JBSandhills



Joined: 29 Jan 2014
Posts: 2

PostPosted: Wed Jan 29, 2014 3:43 pm    Post subject: Reply with quote

Hi Aaron,
It would be nice to have the space removed because it looks a bit strange; however, it's not the end of the world if this feature has to come sometime later. As long as the NODES issue is fixed by stable release, my coworkers and I will be very happy.
Back to top
View user's profile Send private message
Aaron Law



Joined: 28 Jun 2013
Posts: 139
Location: Red Gate Software

PostPosted: Thu Jan 30, 2014 3:04 pm    Post subject: Reply with quote

The xml casing should be fixed for you in 6.3.0.95.
Back to top
View user's profile Send private message
Mr.DiGi



Joined: 06 Feb 2014
Posts: 4

PostPosted: Thu Feb 06, 2014 2:13 pm    Post subject: Reply with quote

Microsoft SQL Server Management Studio 11.0.3401.0
SQL Prompt Pro 6.3.0.102
SQL Search 1.1.9.57
SSMS Tools Pack 2.7.2.0

Instant crash after typing number after GO. In SSMS you can specify how many times should SSMS repeat statement.

Code:

PRINT 'You will see this message 10 times'
GO 10


This works fine with SQL Prompt 6.2.

Edit: Yay, just paste example in SSMS and...
Back to top
View user's profile Send private message
Aaron Law



Joined: 28 Jun 2013
Posts: 139
Location: Red Gate Software

PostPosted: Thu Feb 06, 2014 3:26 pm    Post subject: Reply with quote

Hi Mr.DiGi,

I'm really sorry you've encountered this crash but thank you for reporting it. I can recreate it here and will look into a fix for you, hopefully I'll have a new build out shortly.

Thanks,
Aaron.
Back to top
View user's profile Send private message
Aaron Law



Joined: 28 Jun 2013
Posts: 139
Location: Red Gate Software

PostPosted: Thu Feb 06, 2014 6:05 pm    Post subject: Reply with quote

I've just uploaded 6.3.0.121 which should have a fix for this crash. Thanks again for reporting it!
Back to top
View user's profile Send private message
Mr.DiGi



Joined: 06 Feb 2014
Posts: 4

PostPosted: Fri Feb 07, 2014 10:33 am    Post subject: Reply with quote

No problem, thanks for quick fix.
Back to top
View user's profile Send private message
Mr.DiGi



Joined: 06 Feb 2014
Posts: 4

PostPosted: Fri Feb 07, 2014 11:50 am    Post subject: Reply with quote

More (minor) bugs - User defined table type related:

- Select in Object Explorer is not working for table type
- column names from table type are not listed (maybe this didn't work with previous version too)
- we have custom table type with "Value INT" column. After using column "Value" in join all database object/names disappears from SQL Prompt (only snippets are listed).

demo:

Code:

CREATE TYPE [dbo].[IntTable] AS TABLE
(
   [ID] [int] IDENTITY(1,1) NOT NULL,
   [Value] [int] NULL
)
GO

DECLARE
   @x dbo.IntTable

SELECT
   1
FROM
   @x AS X
   INNER JOIN sys.objects AS O ON O.object_id = X.Value
   INNER JOIN <no hint here>


Just changing "O.object_id = X.Value" to (invalid) "O.object_id = X.ValueZZZ" brings SQL Prompt back.

Edit: Or we can use O.object_id = X.[Value] - maybe because XML type .value, .nodes hacks?
Back to top
View user's profile Send private message
Aaron Law



Joined: 28 Jun 2013
Posts: 139
Location: Red Gate Software

PostPosted: Fri Feb 07, 2014 5:12 pm    Post subject: Reply with quote

Thanks for reporting these, I can recreate them here and we're looking into fixes for them.

I think you are right about the value being mixed up with the xml type value and so Prompt is wrongly expecting parentheses and parameters, which results in it not giving you the correct suggestions.
Back to top
View user's profile Send private message
Aaron Law



Joined: 28 Jun 2013
Posts: 139
Location: Red Gate Software

PostPosted: Fri Feb 28, 2014 11:37 am    Post subject: Reply with quote

Hi Mr DiGi,
Just to let you know, the bugs you mentioned in your last post should be fixed in 6.3.0.188.

Thanks,
Aaron.
Back to top
View user's profile Send private message
Mr.DiGi



Joined: 06 Feb 2014
Posts: 4

PostPosted: Wed Mar 05, 2014 10:34 pm    Post subject: Reply with quote

Awesome, thanks for fixes.

OT: Is there any way to log/debug Qualify object names call? It just hang for our db (almost since beginning).

No error in "....\AppData\Local\Red Gate\SQL Prompt 6\sqlpromptlog-yyyymmdd-hhmmss.log"
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Go to page 1, 2  Next
Page 1 of 2

 
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