SQL Prompt Snippet produces different output when selecting with Mouse vs ENTER key

sajjan

Problem:

Here is the original snippet code:

SELECT top 10 * from $CURSOR$ order  by desc

When i select the snippet using the mouse i get this (this is correct):

SELECT top 10 * from  order  by desc

When I select the same snippet using the ENTER key i get this:

select * from

Example:



SQL Prompt Log At Time of Snippet Typing:




System Details:
SQL Prompt version: 8.0.4.1638 and 9.0.10.4053
OS: Windows 7
SQL Server: 2014

Tianjiao_Li

Hi @sajjan

Thanks for highlighting this issue.

As we discussed in the ticket, upgrading to the latest version (9.1.11.5038 - May 9th 2018) of SQL Prompt and recreating the snippet seem to have resolved the issue.

Please do let us know if it reoccurs.

Thanks!

sajjan

Root cause of the error was that I had another SSMS add-in called SSMSBoost which also had a template called "sel" , so when I typed "sel" and hit enter it was giving priority to the SSMSBoost snippet over SQL Prompt.

Deleting the snippet from SSMSBoost made it work.

RichardL

Hi @sajjan

Thanks for your post. 

I just wanted to check to see if you managed to overcome this issue? 
Please note that if you have a support contract you can always send us a ticket so that a support engineer can look at your issues directly. 

Kind regards

Richard Lynch. 

sajjan

Nope, still happening. Enterred a defect :https://productsupport.red-gate.com/hc/en-us/requests/113505