Page 1 of 1

SET statement wrapping

Posted: Fri 27 Jun 2014 16:21
by bjsafdie
First, I have a paid license to SQL Complete.

I have SQL SET statements that assemble messages. For example (this is all one long, unwrapped line):

Code: Select all

SET @message = 'Start [some processing step] MonthEnding: ' + CONVERT(VARCHAR(25), @MonthEnding, 107) + ', and User = ' + @UserName;
When I format this with SQL Complete, it breaks the line after a plus sign (nice!):

Code: Select all

SET @message = 'Start [some processing step] MonthEnding: ' + 
CONVERT(VARCHAR(25),@MonthEnding, 107) + ', and User = ' + @UserName;
I am fine with that, but note that it does not indent the wrapped line. I cannot find where in the formatting Profile to tell it to indent such wrapped lines. I would prefer:

Code: Select all

SET @message = 'Start [some processing step] MonthEnding: ' + 
				CONVERT(VARCHAR(25),@MonthEnding, 107) + ', and User = ' + @UserName;
Where can you set this kind of wrapping behavior for SET statements?

Thanks.

Re: SET statement wrapping

Posted: Tue 01 Jul 2014 10:04
by alexa
Could you please provide us the full SQL script and the SQL Complete settings file that can be generated as follows:

1. Select 'SQL Complete -> Import and Export Settings' from the main menu.
2. Select the 'Export selected environment settings' option in the wizard and click 'Next'.
3. Select the 'All settings' option and complete the wizard.

You can send a reply straight to our support system at supportATdevartDOTcom, so we will keep further correspondence with you on this issue via e-mail.