Maximize the power of SQL Prompt with SQL Toolbelt Essentials. Watch now.

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

sajjansajjan Posts: 3 New member
edited February 20, 2018 5:39PM in SQL Prompt
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:
eaetipep45gc.gif


SQL Prompt Log At Time of Snippet Typing:
_o_VNpDqSGqz51oAa9jnYw.png



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

Best Answers

  • Tianjiao_LiTianjiao_Li Posts: 684 Rose Gold 5
    Answer ✓
    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!
    Kind regards

    Tianjiao Li | Redgate Software
    Have you visited our Help Center?
  • sajjansajjan Posts: 3 New member
    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.

Answers

Sign In or Register to comment.