INSERT INTO becomes INSERT INTO

hfxDBA

if typing INSERT INTO (1 space between words) or using the built in snippet "ii" there is only 1 space between the key words. if you then choose to format code (ctrl+K, ctrl+Y), an additional space shows up between the key words.

Am I just being oblivious to the option to only have 1 space here, or is this a "feature"?

Anu D

Many thanks for your post.

Can you try selecting this option?

SQL Prompt 5 --> Options --> Format --> Data Statements --> New lines --> Indent subclauses (select this option)

Does this makes any difference?

hfxDBA

selecting this option does remedy this issue, but I do not want sub-clauses indented. As far as my testing has gone, I do not see any other combination of keywords that have 2 spaces between them instead of just 1.

If this is by design, I am not sure of the purpose. It looks out of place when compared to other lines of formatted code using this tool.