SET statement wrapping

[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.

[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.