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

Can I make Sql prompt overwrite snippets with new definition.

Can I make Sql prompt overwrite snippets with new definition? I am on 10.12.4.29949.
When I create a snippet with the same name, Sql prompt asks if I want to overwrite the old definition.
I answer yes, but Sql prompt ends up creating copies.
Moreover, all old copies show up in the suggestion popup with the same names in random order. I have to guess which one is the current one and actually click one of them only to find out that it is an old definition.

My temporary solution is to go to the snippets folder, list them in time order, and delete old ones. But is there a better way? There is a thread, but no answer.

Why SQL prompt stopped overwriting old snippets? — Redgate forums (red-gate.com)

Tagged:

Answers

  • Hi @BenKim

    Thanks for reaching out to us regarding this!

    I have also been able to replicate the behavior you are seeing with Snippets in SQL Prompt, it does appear to be a bug in the application.

    I will be escalating this to our development team for their input on this. I will come back to you on this again as soon as I can.
    Kind regards

    Dan Jary | Redgate Software
    Have you visited our Help Center?
  • Hi @BenKim

    Just to let you know that this is currently still with our development team. 

    I'll update you on this again as soon as I have more information. 
    Kind regards

    Dan Jary | Redgate Software
    Have you visited our Help Center?
  • Hi Dan,

    I'm also dealing with this issue. And it seems like its been an open issue since 2021. Do you have a timeline for when the development team might solve it? Thanks!

    -Seth
  • Hi @BenKim & @sethpourciau

    This is still currently on our development teams' list of work to look at. I'm afraid I don't yet know when this is due to be worked on, however I will keep a close eye on this and will let you know as soon as I have an update.
    Kind regards

    Dan Jary | Redgate Software
    Have you visited our Help Center?
Sign In or Register to comment.