Put Comma on the other side for Select List Completion

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
vinodj
Posts: 3
Joined: Fri 21 Mar 2014 17:08

Put Comma on the other side for Select List Completion

Post by vinodj » Sun 09 Dec 2018 20:38

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
Devart Team
Posts: 2599
Joined: Fri 24 Jun 2011 14:17

Re: Put Comma on the other side for Select List Completion

Post by alexa » Mon 10 Dec 2018 10:25

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
Posts: 3
Joined: Fri 21 Mar 2014 17:08

Re: Put Comma on the other side for Select List Completion

Post by vinodj » Mon 07 Jan 2019 08:46

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
Devart Team
Posts: 2599
Joined: Fri 24 Jun 2011 14:17

Re: Put Comma on the other side for Select List Completion

Post by alexa » Tue 08 Jan 2019 08:44

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.

Post Reply