Style Not Formatting Correctly
BR23
Posts: 3 New member
in SQL Prompt
I created a style and it was working fine. Then all of a sudden some things stopped working. For instance I set the Join to look like this below. It looks fine in the preview mode when creating the style.
SELECT *
SELECT *
FROM dbo.TempTable
INNER JOIN dbo.TempTable2 ON TempTable2.id = TempTable.id;
However, when I actually apply the style it moves the ON to another line. I don't have the box checked to do this and the line is not long enough where it should wrap. Any ideas would be appreciated.
However, when I actually apply the style it moves the ON to another line. I don't have the box checked to do this and the line is not long enough where it should wrap. Any ideas would be appreciated.
SELECT *
FROM dbo.TempTable
INNER JOIN dbo.TempTable2
ON TempTable2.id = TempTable.id;
Tagged:
Answers
That's very odd behaviour, I just copied the default style and turned off "Place ON keyword on a new line" also and it works for me. Could you potentially try copying the default style and apply the settings you've done before and check if that helps?
Kind regards
Dan Calver | Redgate Software
Have you visited our Help Center?
Kind regards
Dan Calver | Redgate Software
Have you visited our Help Center?