How can we help you today? How can we help you today?

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.
gvarol
0

Comments

2 comments

Sort by
  • James R
    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
    James R
    0
  • James R
    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
    James R
    0

Add comment

Please sign in to leave a comment.