Devart Forums

Posted: **Wed 18 Oct 2017 07:45**

How do I achieve the formatting below:
In an older version of SQL Complete i was able to do this.

SELECT
     [Column1]
,    [Column2]
,    [Column3]
FROM
	[Table]

Currently I'm only able to get the formatting below:

Code: Select all

SELECT
     [Column1]
   , [Column2]
   , [Column3]
FROM
	[Table]

Under 'SELECT > Select List' I have the configuration set as below:
- Line break before first column = True
- Indent column list by 4 columns = True
- Indent on new line only = False
- Stack columns = True (and set to 'table view')

I'm currently using dbForge SQL Complete - Standard Edition - version 5.7.206

Posted: **Thu 19 Oct 2017 14:58**

Indeed, that behavior has changed in the new version. Though, you can add a suggestion on our UserVoice forum where other users can vote for it https://devart.uservoice.com/forums/87893-sql-complete.

We collect and analyze the information from this forum in order to make a proper roadmap for the future product releases.

Posted: **Sat 21 Oct 2017 10:04**

Hi Alexa,

Thanks for your response. So it seems that I have to request functionality that was already in (and taken out for maybe very valid reasons) and have others vote for it to make it important enough?

Currently most of the projects I've written SQL for is formatted as I requested and as of now I have to either reformat everything the way that's supported now or just ignore it.

If it's simple funcionality to put back in I would sincerely like to have it back.

Best regards,

Posted: **Mon 23 Oct 2017 16:21**

Thank you for bringing this to our attention.

We will reconsider this when developing the next product versions.

Devart Forums

Column List formatting, indent 'after' komma

Column List formatting, indent 'after' komma

Re: Column List formatting, indent 'after' komma

Re: Column List formatting, indent 'after' komma

Re: Column List formatting, indent 'after' komma