Comments
Sort by recent activity
The JSON file is there now the date stamp says it was created at 11:57pm (well after my print screens above.) Why would the JSON file not be written immediately? It seems that the delay might be related. / comments
The JSON file is there now the date stamp says it was created at 11:57pm (well after my print screens above.) Why would the JSON file not be written immediately? It seems that the delay might be ...
I just recreated the missing "stwh" snippet again tonight and the snippet shows in the list, but the JSON file was not created, or it's already been removed. The snippet is showing in SQL Prompt and it's working, but the JSON file hasn't been created. I'm able to use the snippet currently, but I'm skeptical that I will be later. I think the point of failure is that the JSON files are not always written. [image] [image] / comments
I just recreated the missing "stwh" snippet again tonight and the snippet shows in the list, but the JSON file was not created, or it's already been removed. The snippet is showing in SQL Prompt a...
New clue: After I deleted and recreated the snippet earlier today, the snippet was present. Now a few hours later, the snippet is no longer in the snippet folder and not listed anymore. It seems something is causing them to be removed after they're saved. The snippet folder is located in : C:\Users\(MyUserName)\AppData\Local\Red Gate\SQL Prompt 10\Snippets. The only snippets I have in the folder were the original snippets plus 6 I created 30 minutes after installing based on the Date Modified. It seems I'm missing all the snippets created after that point. This is bizarre. / comments
New clue: After I deleted and recreated the snippet earlier today, the snippet was present. Now a few hours later, the snippet is no longer in the snippet folder and not listed anymore. It seems...
I have been a user of SQL Prompt for years, but this was a new install of it at a different employer and it was the original install (never updated.) I was able to save a more simple example just now, so it seems that it only happens some of the time. When I attempted the problem snippet, it kept looking like it worked in the Snippet Manager UI, but wouldn't show in the list. I checked the files in the folder and the Snippet JSON file was not created. I eventually just manually created the JSON file and then it appeared in the list immediately and worked correctly. The Snippet folder is the default local location. It isn't a permissions issue since I was able to save the file manually. I'm wondering if it's something specific within my snippet that caused it. I'm able to successfully edit the problem snippet though. I deleted it and successfully recreated it too just now. I created a bunch the first day I used it and it seems that a few are missing that I expected to have been there. I'm at a loss currently as to what could have caused it. I just know it didn't get completed the first time I tried. When I attempted to use it the first time a few days later, I realized it wasn't in my list. I then tried multiple times to create the Snippet, each time the Snippet Manager seemed to work, but each time the JSON file wasn't written. So I confirmed the issue was with the Snippet Manager writing the JSON file, but I can't repeat it now. I could repeat it multiple times that day though. / comments
I have been a user of SQL Prompt for years, but this was a new install of it at a different employer and it was the original install (never updated.)I was able to save a more simple example just no...
I'm using the latest version of SQL Prompt: 10.11.9.27382 / comments
I'm using the latest version of SQL Prompt: 10.11.9.27382