SQL formatting not working in 0.2.5

• 
  Same error for me-it looks like my custom format is not loading in on V0.2.5. I now only see "Default, Collapsed, Comas before, Indented and Right aligned Built In formats. No custom formats.

  PaulMoran January 11, 2021 16:10

  - 0 +
• 
  Just reporting in... I just updated to 0.2.6 a few minutes ago. This bug still exists. Thanks

  JeffEdmunds February 01, 2021 20:51

  - 0 +
• 
  I've installed 0.2.7 and am now getting a slightly different error, basically stating that it couldn't find my formatting style document on D drive path which I don't have on my machine.
  
  I tried creating a new style document, copying from one of the defaults, and it appears to create a JSON formatted file in:
  ...\AppData\Roaming\azuredatastudio\User\globalStorage\redgate.sql-prompt\styles
  
  My original styles document, which I believe is shared between SSMS & Visual Studio, is an XML formatted file, stored in:
  ...\AppData\Local\Red Gate\SQL Prompt 10\StylesV2
  
  I tried copying the XML file from the main folder to the ADS folder, but it couldn't seem to see or read it.  I've gone ahead and started modifying the JSON settings file, just so I can start using prompt again in ADS.  However, if there's a way that I'm forgetting or missing to get Prompt in ADS to use the same shared file as SSMS & VS, please let me know. Thanks!

  JeffEdmunds May 06, 2021 13:56

  - 0 +
• 
  I had the same issue with 0.2.6 so I went back to 0.2.5. Unfortunately it has forced me to update today. I've just tried 0.2.7 and got the same issue as JeffEdmunds above. It appeared to be looking for it on a D drive which I also don't have.
  

  warrenj May 13, 2021 09:02

  - 0 +
• 
  Problem solved: The solution was that I needed to update my version of SQL Prompt for SSMS too.

  warrenj June 29, 2021 13:52

  - 0 +
• 
  @warrenj This worked for me as well. Thanks!!

  JeffEdmunds June 29, 2021 14:31

  - 0 +

Add comment

Please sign in to leave a comment.