SQLPrompt fails to format a valid SQL (version 8.0.2.1508)

gvarol@corelogic.comgvarol@corelogic.com Posts: 90 Bronze 3
in SQL Prompt
Trying to format this code I get "Error applying column alias style", I do not see anything highlighted as error.
Tagged:
· Share on Twitter

Comments

  • James RJames R Posts: 104 Silver 4
    Hi @gvarol@corelogic.com ,

    Thanks for the post! I've managed to track this down to the CASE statement inside a select column list. If the WHEN clause has multiple conditions then the error occurs. We've logged the error here and will look into it this week.

    As a workaround for now you can go to SQL Prompt > Options > Format > Styles and uncheck the 'Apply column alias style' checkbox :)

    Hope this helps!
    James
    Software Engineer
    Redgate Software
    · Share on Twitter
  • James RJames R Posts: 104 Silver 4
    Hi again @gvarol@corelogic.com ,

    Just to let you know we've just released version 8.0.3.1587 of SQL Prompt which should fix this issue.

    Regards,
    James
    Software Engineer
    Redgate Software
    · Share on Twitter
Sign In or Register to comment.