Backspace strangeness

Not sure if this is supported since I'm on Linux/Wine. I don't know if this also happens on Windows, because I guess someone would have mentioned it by now and I found nothing here.

I'm currently running HeidiSQL 10.2.0.5669. Whenever I'm in a grid (table data, table editing) and I press backspace, the active tab looses focus and the first tab called "Host [...]" becomes active. Del(ete) works as expected, but.. the number of times I press Backspace and end up in another tab.. well, it's quite annoying. ;-)

I'm unsure about when this started, but I do know this didn't use to happen in a previous version. Is it something that can be fixed?

In fact, I booted a Windows PC, updated to the latest version and it doesn't happen there.

+1.

Backspace has this unexpected behavior. Including when editing data.

wine-4.12.1 (Staging) Heidisql 10.2.0.5608

Maybe it's that "Go to" menu item which does that, although I don't guess you have set your backspace key as shortcut for it. But maybe it helps to remove the default one (Ctrl + 1), in Tools > Preferences > Shortcuts?

to remove the default one (Ctrl + 1)

unfortunately it's useless...

There is same situation in Heidisql 9.4. I suppose the changes in wine are to blame.

Can confirm this happens when under the influence of wine. Editing fields is insanity.

Are you experiencing the same issue in some other Windows app under the same Wine version?

Are you experiencing the same issue in some other Windows app under the same Wine version?

In other Windows applications under the same Wine version it works correctly

Also confirming the Backspace issue on Linux (Manjaro). Happens to me in all HeidiSQL 64-bit versions 9.5 onwards.

Must have something to do with Wine. As a temporary workaround I downgraded Wine to version 4.1-1 and now it works. In every version above that (tried 4.10, 4.11, 4.12, 4.13, and 4.15), hitting backspace while editing a field in the grid just focuses the "Host" tab.

I noticed that this is also happening in the Preferences window, when trying to assign the Backspace key to a shortcut: When the shortcut textbox is focused and I press Backspace, the tab focus is shifted to the "General" tab of the Preferences window. Looks like it must be for the same reason.

I can also confirm the behavior. After updating to the current Codeweaver Crossover (Wine 4.12.1), the behavior also occurs in a Mac environment. Because of MacOS Catalina the update to the latest Wine version is unavoidable. The problem does not occur in Heidi's SQL Editor. But if I want to change a value in the data view within a column/cell, the backspace key cannot be used.

I can also confirm that HeidiSQL 10.2 works perfectly on wine 1.6.2, but on wine 4.17 I'm having above described "backspace problem".

I gave up on using heidi with wine a long time ago. I just use a VM for it with clipboard sharing and be done with it. Crashes and other odd behavior are becoming more common with it under wine.

I think the "works with wine" text should be removed until thoroughly tested/bugfixed for current-gen wine releases.

I think the "works with wine" text should be removed

Sad but true. I suppose it's fair to change that into something like "may work with Wine, but untested".

Yeah nah sorry, it's not great at the moment. I wouldn't even say that at the moment.

Adding fuel to the fire, wine 5.0 just got released today. :)

Actually, HeidiSQL works fine with wine! I've had it working with all major versions of wine including 5.0-dev.

The problem with backspace is easy to solve. You just have to unassign Ctrl + 1 not only from "Goto Marker 1" but also from Various -> Tab 1 then restart.

I love HeidiSQL! To me this is the best software for working with MySql! I can't say enough to express my admiration and gratitude to the author!

That's not a solution, that's a workaround.

Regardless, thank you for sharing. Hopefully that could narrow down why the behaviour started out of the blue in the first place.

The problem with backspace is easy to solve. You just have to unassign Ctrl + 1 not only from "Goto Marker 1" but also from Various -> Tab 1 then restart.

Unfortunately this didn't work for me :(

I love HeidiSQL! To me this is the best software for working with MySql! I can't say enough to express my admiration and gratitude to the author!

+1 :)

I can confirm the backspace issue is resolved by using Wine 4.8, until the Wine developers have fixed the issue.

With these commands I installed Wine 4.8 in Debian Buster:

wget dl.winehq.org/wine-builds/debian/dists/buster/main/binary-amd64/wine-staging_4.8~buster_amd64.deb

sudo apt-get install wine-staging-i386=4.8~buster wine-staging-amd64=4.8~buster

sudo dpkg -i ./wine-staging_4.8~buster_amd64.deb

Wine 4.8 will be installed in /opt/wine-staging/

In follow up to my post above, you could have to make a symlink to be able to access wine easily:

sudo /opt/wine-staging/bin/wine /usr/bin/wine

This happens on Ubuntu 20.04 and Wine 5.18 Editing fields is extremally hard :(

I know it's been awhile but if you're still dealing with this issue, I tried all of the fixes above to no avail, so I tried installing Heidisql wine from the snap software package manager and the problem is non-existent and it adds Heidisql as an executable. Hope this helps someone.

Sorry I forgot to add I'm using Ubuntu 22.04 Desktop.

Hey, ya know what, now after testing it's even worst. I'm done with Heidisql on linux. Dbeaver-CE works well.

I'm using HeidiSQL 10.2 under Ubuntu 20.04. almost on daily basis. It works very stable without any problems (and no backspace problem). The backspace problem is very annoying but with the wine-staging-6.1 (version 6.1~focal-1) there is no backspace problem (i'm using 64bit standalone heidisql version) - works out of box.

As far as I know it's a wine problem (depends which version you use) - I didn't have backspace problem on the old version of wine (1.6.2)

Installing from snap solved the backspace-problem for me

sudo snap install heidisql-wine --beta