SQL Prompt not formatting

ddatsc

I just installed SQL Prompt and set my formatting style. When I clean "Preview current query" I can see the changes are what I want. When I go to SQL Prompt>Format SQL the screen flashes like it did something but the query is exactly the same. 

Any suggestions for a fix would be appreciated

Version 10.13.7.360

Jon_Kirkwood

Hi @ddatsc

Thank you for reaching out on the Redgate forums and sorry to hear about your formatting issues with SQL Prompt.

If possible, are you able to enable Verbose Logging and recreate this screen flash and then provide the log files
Details on getting logs can be found here:
https://documentation.red-gate.com/sp/troubleshooting/finding-the-sql-prompt-log-files
To enable verbose logging it is found in SQL Prompt > Help > Enable Verbose Logging

If you can also provide a copy of your formatting style and if possible the code snippet you are working on that highlights the issue it will help to replicate this issue and work towards a solution.

I have generated this secure file storage link for your files, so they don't need to be shared over the public forum. This link will be valid for 14 days.
https://files.red-gate.com/requests/hXgR0UVXUdscP2Vq6McOcq

Jon_Kirkwood

Thank you for your patience whilst this was worked on by our development team.

Are you able to patch into the latest version and advise if this formatting process has been resolved.

 

Download link for v10.13.9 available here:

https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.13.9.869.exe