Format Case Confuses Functions with Keywords
AndyJost
Posts: 4
I use the case formatting in the pro edition to format reserved words as uppercase and functions as "Leave as is".
When I type "left outer join", the formatting treats "left" as a function and formats the text as "left OUTER JOIN". If I change the function formatting to uppercase, it correctly converts all three words to uppercase. Right outer join has the same issue.
I guess I really should be using the loj snippet!
Apart from that, the new UI looks great and it feels much more responsive (although I've only been using the new version for a few hours).
When I type "left outer join", the formatting treats "left" as a function and formats the text as "left OUTER JOIN". If I change the function formatting to uppercase, it correctly converts all three words to uppercase. Right outer join has the same issue.
I guess I really should be using the loj snippet!
Apart from that, the new UI looks great and it feels much more responsive (although I've only been using the new version for a few hours).
Comments
Thanks for very clear explanation of issue I was able to reproduce it easily.
I have logged this issue as a bug whose reference number is SP-2765
Kindly let me know if you have any other issue regarding SQL prompt, I'll like to help.
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com