Doesn't capitalize keyword where

Oliwa

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.

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.

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.

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

Did you got a chance to check the settings suggested by me in previous post?

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.

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.