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

Suggestion: Complete should eat rest of word

Hi there.

I've been using the new beta of SQL Prompt today, and I must say that it is a great step forward from the previous beta (and version 2)

I have one suggestion, though.

I would like the complete to overwrite the rest of the word that is being completed.

Say, I have the following code:

SELECT
dbo.MenuItem.MenuID
FROM dbo.MenuItem

I want to change the MenuID into MenuItemID

I navigate to ".Menu" and start typing "it". I get the popup suggesting "MenuItemID", so I press Enter to use that.

the code now reads:
SELECT
dbo.MenuItem.MenuItemIDID

I would like to get the code to read:
SELECT
dbo.MenuItem.MenuItemID

This would also be helpful for when you're editing old scripts / view definitions without the correct object casing. You can then just move the cursor over to a part of the object name, press ctrl+space and Enter to fix the case.
Turambar
0

Comments

2 comments

Sort by
  • Tilman
    Hi,

    I've added your suggestion to our list.

    Regards,

    Tilman
    Tilman
    0
  • Bart Read
    Ooooooh contentious. If we were to do that I think it would have to be a configurable option since some people (like me as it happens) would find it incredibly irritating. I used to use a version of IntelliJ IDEA from JetBrains that did this and it used to wind me up something chronic, except on the odd occasion when that was actually what I wanted it to do, so I'd certainly agree that it can be useful.
    Thanks,
    Bart
    Bart Read
    0

Add comment

Please sign in to leave a comment.