On-demand training: More Gems from the SQL Prompt Treasure Chest. Watch now.

formatting if else if statements

russ0519russ0519 Posts: 3 New member
edited March 15, 2016 9:30AM in SQL Prompt
I want the formatting to be as follows:
IF ()
STATEMENT
ELSE IF ()
STATEMENT
ELSE IF ()
STATEMENT
ELSE
STATEMENT

However, currently, it formats like this:

IF ()
STATEMENT
ELSE
IF ()
STATEMENT
ELSE
IF ()
STATEMENT
ELSE
STATEMENT
Is there an option that fixes this?

Comments

  • Ali DAli D Posts: 56 New member
    Hi

    Thanks for posting. It looks like the forum might have stripped out some of the whitespace in your examples. We have a UserVoice request for controlling how nested IF ELSE statements are formatted here:

    https://redgate.uservoice.com/forums/94 ... ing-of-els

    If this looks like the same formatting style that you would like, please add your vote and you’ll get notified as soon as we release a build with this functionality included. We’re currently hard at work developing a new, more powerful formatting engine.

    Thanks
    Ali
Sign In or Register to comment.