Switch to/from Column Picker

fgsimon

Hi,

I find it very annoying every time the popup appears when I don't really need it and I just want to move to the next word (which I always do using CTRL+Right).

I would like to move 'Switch to/from Column Picker' away from CTRL+Left and CTRL+Right, is that possible?

peter.peart

Thanks for your post. You can do this, but it's not entirely elegant. If you go into C:\Users\%user%\AppData\Local\Red Gate\SQL Prompt 5 you should find a file called RedGate_SQLPrompt_CommonUI_Options_UIOptions.xml.

In that file, you'll find the following strings:

<EnableCtrlLeftCtrlRight>True</EnableCtrlLeftCtrlRight>
<EnableShiftlLeftShiftRight>False</EnableShiftlLeftShiftRight>

All you need do is change them to the following:

<EnableCtrlLeftCtrlRight>False</EnableCtrlLeftCtrlRight>
<EnableShiftlLeftShiftRight>True</EnableShiftlLeftShiftRight>

The column picker itself still says that to enable it hit CTRL+Left etc, but it's actually Shift that operates the switching to and from.

HTH!

Pete

fgsimon

Thank you very much, a perfect solution!