How can we help you today?

How can we help you today?

BUG - Format SQL

Hi,

When trying to format the following code, I get the incorrect syntax error.

CREATE TABLE dbo.test (desc VARCHAR(128))

I'm assuming formatting fails when it finds a SQL keyword in such case.

Version : 9.5.21.11921

Thank you

Named October 16, 2019 18:22

0

Comments

5 comments

Good Afternoon!
Can you send me a screenshot of the particular error message that you get? Can you also send me a screenshot of your options under Format>Styles?

Thanks!

squigley October 17, 2019 21:54

0
Sure

etwty October 17, 2019 22:49

0
Thanks for sending me that screenshot.
I was able to replicate the issue on my test machine. I'm gonna check on my end to see why this might be the case and get back to you.

squigley October 22, 2019 23:29

0
Good Afternoon!
Out of curiosity, if you try surrounding [DESC] with square brackets, does the issue go away?

squigley October 24, 2019 20:02

0
Good afternoon!

Yes, the formatting works when I surround sql-keyword-like field names and press ctrl + K, ctrl + Y.

etwty October 29, 2019 19:00

0

Add comment

Please sign in to leave a comment.