Sql Prompt for ADS

Sql Prompt for ADS is lackin the ability to import snippets that have multiple prefixes defined.  ADS has the ability to define a prefix for a snippet as follows:

    "Inner join": {
      "prefix": ["inner","ij"],
      "description": "inner join fragment",
      "body": [
        "inner join "
      ]
    },

The prefix for the inner join snippet is triggered by either typing "inner" or by typing "ij", either one works.  Unfortunately if the sql.json file contains a snippet defined as above it does not import any of the snippets.  The only work around I have found is to not use multiple prefixes (which I prefer to define as that is the way I work best)

Is this something that Redgate can fix or is there a way to define the snippet with multiple prefixes in a manner that Sql Prompt can import.

Comments

  • cstyvecstyve Posts: 4 Bronze 1
    After removing all multiple prefixes now getting this error. No indication of which file is causing the error.  

    Failed to import snippets from SSMS: Error: Value cannot be null. (Parameter 'key')

    This error occurs even if the sql.json file is completely empty.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file