On-demand training: More Gems from the SQL Prompt Treasure Chest. Watch now.

Snippits not working on a new install

ptrongoptrongo Posts: 4 Bronze 2
I just installed SQLPROMPT10.6.16.21150 on a new machine.  everything seems to be working, except Snippit Manager.
Its not recognizing any existing snippits in my team's shared folder. I Can see the folder, can see the scripts, can edit the scripts, but not in Prompt.

Answers

  • Hi @ptrongo

    Please can you check the folder where the snippet files are stored (usually: \User\AppData\Local\Red Gate\SQL Prompt 10\Snippets) to see if they have all been converted to the new JSON file format? Or are there any duplicates in here?

    Could you also check C:\Userl\AppData\Local\Red Gate\SQL Prompt 10\Styles, could you send a screenshot of the files located in that folder if any? 
    Kind regards

    Victoria Wiseman | Redgate Software
    Have you visited our Help Center?
  • ptrongoptrongo Posts: 4 Bronze 2
    @Victoria W
    It looks like they were converted.  Here is one example. Jason files are in there with the original name and a unique identifier. 

    There is nothing in the mentioned Styles folder. Additionally, the Tab History isn't working either. 

    Old File (from a directory I copied off prior to upgrade)
    stat.sqlpromptsnippet
    =======================================================
    <?xml version="1.0" encoding="utf-8"?>
    <CodeSnippets>
      <CodeSnippet Format="1.0.0">
        <Header>
          <Title>stat</Title>
          <Shortcut>stat</Shortcut>
          <Description>Set Statistics on</Description>
          <Author />
          <SnippetTypes>
            <SnippetType>Expansion</SnippetType>
          </SnippetTypes>
        </Header>
        <Snippet>
          <Declarations />
          <Code Language="sql"><![CDATA[set statistics io on 
    go
    set statistics time on]]></Code>
        </Snippet>
      </CodeSnippet>
    </CodeSnippets>

    New File
    stat-fa1100dc-3891-447c-9182-1af333162cc9.json
    ========================================================
    {
      "id": "fa1100dc-3891-447c-9182-1af333162cc9",
      "prefix": "stat",
      "description": "Set Statistics on",
      "body": "set statistics io on \ngo\nset statistics time on"
    }
  • Jessica RJessica R Posts: 1,315 Rose Gold 4
    Thanks @ptrongo!

    Can I just check if you are you getting any errors when typing a query?

    What location is your Snippets pointing to? By any chance do both your Styles and Snippets folders exist as subfolders of that location?

    Can you please share more detail on how Tab History isn't working? Is it throwing any errors?

    Thank you!

    Jessica Ramos | Product Support Engineer | Redgate Software

    Have you visited our Help Center?


Sign In or Register to comment.