Put Comma on the other side for Select List Completion

[vinodj]

Does anybody know how to have the comma for the SELECT List appear on the right hand side of every field instead of on the left hand side.
I tried to change the formatting list but it did not stick.

Thanks,
Vinod

[alexa]

This can be setup as follows:
1. Select 'SQL Complete -> Options...' from the main menu. The 'Options' window opens.
2. Navigate to the 'Formatting -> Profiles' branch.
3. Select the active profile and click the 'Edit Profile...' button. The 'Edit Profile...' window opens.
4. Navigate to the 'Stacked List' node.
5. Unselect the 'Place comma before item in stacked list' option.
6. Click 'OK'.

If this still doesn't work, please provide us the full script and let us know what product version you are using.

You can send a reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .

[vinodj]

On version 6.0.79
When I try that - the profile does not save and goes back to the original comma list.
I cannot install the latest version as that causes SSMS 17.9.1 to not start up at all
when I installed it.

[alexa]

Thank you for the reply.

Could you please perform the following:
1. Close SSMS.
2. Download and unzip the file http://devart.com/pub/TraceOn-Off.zip .
3. Run the file trace_on.reg from the archive.
4. Start SSMS.
5. Reproduce the issue.
6. Send us a *.log file with the latest date from the following folders:

Code: Select all

\%AppData%\Devart\dbForge SQL Complete\
\%AppData%\Devart\SqlCompleteIntegrationModule\

7. Close SSMS.
8. Run the file trace_off.reg from the archive in order to stop tracing.