SQL formatting not working with 0.2.3 version of the extension.

SzymonOs

After installing the latest 0.2.3 SQL Prompt version SQL formatting stopped working (it did work on previous version).
The extension is properly installed (I've also reset settings, uninstalled the extension and install it again), the snippets are working, but I have no option to use SQL Prompt to format code.
When I choose the option "Format Document With..." I can only select mssql formatter, there is no Redgate SQL Prompt on the list.
I'm using ADS v1.23.0.

AdrianB

@SzymonOs @Emanuel_B The link above should get you the latest version, but it does have a cache expiry on it, so you might be hitting that. The direct download link is: https://download.red-gate.com/EAP/SQLPromptADS/SQLPromptADS_0.2.4.0.zip.

AdrianB

@SzymonOs Thanks for letting us know. We've tracked down the problem and released v0.2.4 that should fix the issue.

SzymonOs

Great. Where can I download 0.2.4 version?
ADS can't see any updates and when I try to download from https://download.red-gate.com/EAP/SQLPromptADS.zip it saves the 0.2.3 version.

Emanuel_B

Piling on, @AdrianB. Where is the 0.2.4 version?????

SzymonOs

It's working again. Thank you for fast response .

ADSuser11

I have the same problem.
Windows 10
SQL Prompt 0.2.12
Azure Data Studio 1.37.0

rich20509

Hello there,
Make sure you are using the upgraded version and check the IDE compatibility.
Also you can downgrade the extension to a previous version.

Hope this will help.

Balkoth

I also have this problem.
Windows 10
SQL Prompt 0.2.12
Azure Data Studio 1.47.0

Could not get it to work with either 0.2.11 or the previously mentioned 0.2.4, so this may be a problem with Azure Data Studio itself?

Please investigate, as i can not work on SQL without SQL Prompt.

Balkoth

I guess i figured out my problem. The extension is calling an unsigned exe in the extension directory. Running exe files is generally blocked by AppLocker in our corporate environment.

Please keep this in mind and maybe offer a solution when going forward with the extension.