SQLinForm SQL FormatterCommunity Discussion Forum
SQLinForm SQL Formatter
I have a Pro license. I am running VS Code and Visual Studio 2022.
In VS Code, I am using the 'Desktop App Location' setting to manage all my preferences. I make a change in the Desktop App and it is immediately available in VS Code. This tells me that I know where the 'Desktop App Location' is on my computer. Curious note, it has a trailing slash e.g. C:\Users\tangomike\ONEDRI~1\Documents\
Now I am trying to do this in Visual Studio 2022. I have the extension installed. I've gone to Tools, Options, SQLinForm, General and put in the same file location that I use in VS Code. It doesn't work. I edit it and remove the trailing slash so it looks like the picture on Download Visual Studio 2022 Plugin
Still doesn't work. I am using the standard 'Profile 1' and haven't renamed it in the Desktop app.
Any thoughts?
Hi @tangomike,
thanks for your feedback.
Did you select/highlihgt the sql statement in vs2022 before you chosse the format action?
Regards
Guido
Please try with a simple SELECT statement
Just tried a not so simple select in VS and SQLinForm worked perfectly. Thank you. SQLinForm extension is working then. 😀
Now it is strange that the DECLARE statement in VS does not format the same way as DECLARE in SQLinForm Desktop.
I do have the DECLARE statement highlighted/selected when I choose Profile 1. I just tried that SQL in SSMS 20 and it formats the same way as VS.
When I do that SQL in "Visual Studio Code" it formats like it shows in SQLinForm Desktop.
Mildly different subject, I would like the semicolon (statement delimiter) to be on a separate line. It works as expected for SELECTs but does not for DECLARE.
i upgraded the version of the VS Plugin to the most recent version
Please uninstall your Plugin
Download and unzip the zip file which includes new version of the vsix file and the new Profile Manager from here: https://www.sqlinform.com/download-visual-studio-2022-plugin/
Update the location in the General Options to the location of the Profile Manager (downloaded and unzipped)
Now the formatting should be identical in Profile Manager and the Plugin
Thank you! That worked!
