How can we help you today? How can we help you today?

Doesn't capitalize keyword where

When I type a query such as this...

SELECT *
FROM sys.databases
where [name] = 'temp'

I will capitalize SELECT and FROM when I hit tab, but not WHERE. It also capitalizes GROUP BY and ORDER BY, but not WHERE.

It does capitalize WHERE if I hit the space bar before hitting tab.
Oliwa
0

Comments

6 comments

Sort by
  • Anu D
    Many thanks for your post.

    Can you kindly explain us what exactly you type after keyword WHERE?

    As when I type WHERE and press space to type [Name] my WHERE keyword gets capitalised.
    Anu D
    0
  • Oliwa
    I hit the TAB key.

    So I type...

    SELECT<TAB><TAB>*<ENTER>
    FROM<TAB><TAB>dbo.MyTable<ENTER>
    where<TAB><TAB>1 = 1;

    My insertion keys for SQL Prompt at ENTER and TAB. Everything else is unchecked.
    Oliwa
    0
  • Anu D
    Thanks for the update.

    I typed as per specified by you in previous post as soon as I type <Tab> after WHERE it gets capitalised.

    Can you kindly check the settings SQL Prompt 4 --> Options --> Format --> Case and check Reserved Keywords is selected as UPPERCASE?
    Anu D
    0
  • Anu D
    Did you got a chance to check the settings suggested by me in previous post?
    Anu D
    0
  • MikeyC
    Oliwa,

    What version of SQL Prompt are you using? I suspect your problem may have been fixed in the 4.0.2.53 update. My issue with the case not being updated after hitting enter was. (Here is a link to my post: http://www.red-gate.com/MessageBoard/vi ... php?t=9461)

    Anu,

    I have seen this happen as well even with the new version, but I can't reproduce it on demand.
    MikeyC
    0
  • Anu D
    Hello CodantiM,

    At any stage if you are able to reproduce the issue kindly let me know the pattern.

    Many thanks for your post.
    Anu D
    0

Add comment

Please sign in to leave a comment.