Disable keyboard shortcuts (selectively)

[kytrinyx]

Is there a way to selectively remap or disable shortcuts?

In almost all the software I use, the key combination control-h (^h) acts as delete. I haven't used backspace for years (and I avoid stack-overflow and other sites where ^h is remapped to mean something else, because it's so incredibly frustrating to type when every typo triggers something rather than deleting stuff).

[stuconnolly]

Shortcuts can be changed in OS X's System Preferences under Keyboard.

[kytrinyx]

Thanks!

[kytrinyx]

I have not figured out how to do this.

I tried looking for existing mappings in System Preferences > Keyboard > Shortcuts
I looked everywhere, but in particular expected to find something under "App Shortcuts".

I unclicked the existing shortcut for "All Applications > Show Help Menu", even though that was mapped to something other than ^-h, but this did not change the behavior of the app.

Since there was nothing there, I also tried adding a new shortcut for Sequel Pro to match the "MySQL Help" menu item, hoping that it would overwrite the existing one, but this did not help either.

[abhibeckert]

I've been able to confirm this, the Control-H keyboard shortcut is not using a menu item so it cannot be changed via System Preferences.

I didn't know about ^h... but I use ^d and others all the time and will also be working ^h into my workflow. Thanks!

[dmoagx]

Actually ^H has a menu item (it's in the context menu of the query editor) but yeah, reassigning doesn't work.

[abhibeckert]

We have "MySQL Help" in the Help menu, I think we should add "MySQL Help for Word" to the Help menu as well, and put the shortcut there.

Also I suspect the NSTextView subclass is actually the one looking for the ^H keypress? Haven't checked... but if so, we could just remove that once there is a help for word menu item.

[kytrinyx]

I didn't even realise there was a context menu for the query editor, that makes sense.

Thanks for taking the time to dig into this, @abhibeckert

[abhibeckert]

@kytrinyx Shortly there will be a new nightly build (http://nightly.sequelpro.com/) with a menu item in the Help menu that you can change the shortcut of.

Note it has two titles, depending whether any text is currently selected in the editor. So you need to define it twice, like this:

[kytrinyx]

I'm so excited about this. Thanks so much for fixing it!

[kytrinyx]

It works beautifully.

[thisiswei]

@kytrinyx @abhibeckert Awesome! I just ran into the same problem, what do I need to do to remap ^H to delete?

[kytrinyx]

@thisiswei if you get the nightly build then you need to change the two shortcuts listed above (help for word, help for selection). Once those are defined to be something other than ^h, then ^h for deletion will work.

[thisiswei]

@kytrinyx Great! Do you experience any problems with the nightly build?

[kytrinyx]

@thisiswei No I update regularly and have never experienced any problems.

[thisiswei]

@kytrinyx Great!

[twlz0ne]

defaults write com.sequelpro.SequelPro NSUserKeyEquivalents '{
    "MySQL Help for Selection" = "@^h";
    "MySQL Help for Word" = "@^h";
    "back-word" = "^h";
}'

[killrazor]

Came here to find ⌘ + return to execute a query (like MySQL Workbench).

Found that I can map using mac Key bindings with the names of Run Current Query and Run Previous Query.

If you want to do it how @twlz0ne suggested it would be:

 defaults write com.sequelpro.SequelPro NSUserKeyEquivalents '{
        "Run Current Query" = "@\\U21a9";
        "Run Previous Query" = "@\\U21a9";
    }'

Note: you may have to restart the app.