SQLinForm SQL Formatter

Posts: 5

TangoMike

Topic starter

Jun 26, 2025 4:14 pm

(@tangomike)

Member

Joined: 1 year ago

[#136]

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?

5 Replies

Posts: 295

Guido

Admin

Jun 26, 2025 10:29 pm

(@admin)

Member

Joined: 5 years ago

Hi @tangomike,

thanks for your feedback.

Did you select/highlihgt the sql statement in vs2022 before you chosse the format action?

Regards

Guido

Reply

Posts: 295

Guido

Admin

Jun 26, 2025 10:32 pm

(@admin)

Member

Joined: 5 years ago

Please try with a simple SELECT statement

Reply

Posts: 5

TangoMike

Topic starter

Jun 27, 2025 3:52 pm

(@tangomike)

Member

Joined: 1 year ago

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.

Reply

Posts: 295

Guido

Admin

Jun 28, 2025 9:35 pm

(@admin)

Member

Joined: 5 years ago

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

Reply

VS 2022 extension not working