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

Automatically Capitalization not working with (nolock)

The Automatically Capitalization does not work with "(nolock)" even after I added the custom keyword of "(NOLOCK)".

Seems like the paranthesis is causing it not to work properly.

However, this program is totally awesome and I would use it even if it didn't have an option for Auto Capitalization. I just wrote it here because it seems like it should be able to work.
inV1NC3ble
0

Comments

2 comments

Sort by
  • Chris Howarth
    You should be able to get this to work if you add NOLOCK into the 'Keywords to capitalize' list then use the following format:

    SELECT *
    FROM dbo.Table ( NOLOCK )

    Note the space before NOLOCK.

    Hope this helps.

    Chris
    Chris Howarth
    0
  • Bart Read
    Hi inV1NC3ble,


    Thanks for reporting this, and thanks to Chris for the workaround. Unfortunately we're aware of issues with parentheses interfering with both capitalisation and intellisense functionality in the current version of SQL Prompt. We'll be addressing this in version 3 which will have a much more robust parsing model which we're developing from scratch. Sorry I can't provide you with a more direct solution now, but hopefully Chris's workaround will sort you out for the time being.


    Many thanks,
    Bart Read
    0

Add comment

Please sign in to leave a comment.