What are the challenges you face when working across database platforms? Take the survey
Options

SQLPrompt fails to format a valid SQL (version 8.0.2.1508)

Trying to format this code I get "Error applying column alias style", I do not see anything highlighted as error.
Tagged:

Comments

  • Options
    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
  • Options
    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
Sign In or Register to comment.