What are the challenges you face when working across database platforms? Take the survey
Options

Format Case Confuses Functions with Keywords

AndyJostAndyJost Posts: 4
edited August 18, 2009 7:58AM in SQL Prompt Previous Versions
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).

Comments

  • Options
    Anu DAnu D Posts: 876 Silver 3
    Many thanks for your post.

    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.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
Sign In or Register to comment.