Do not save data changes on arrow keys, mouse click, lost focus.

[dezlov]

Steps to reproduce this issue

1. Edit a row cell using the built-in data editor.
2. Press up/down arrow keys OR mouse click on a different row OR click outside of the data editor.

Current behavior

Booom! Data is saved!

• Incomplete changes - SAVED.
• Inconsistent changes - SAVED.
• Accidental changes - SAVED.
• Unverified changes - SAVED.

Expected behavior

Do no save data until user executes a very obvious and explicit "SAVE CHANGES" action, such as a dedicated button click.

Possible solution

Add a very obvious "SAVE CHANGES" button, which could also ask the user for a confirmation to apply the changes.

Bonus: Display the queries to be executed in the confirmation dialog.

Environment

Version 9.5.0.5320 (64 Bit)
Compiled on: 2018-10-31 06:52:11
Environment: Windows 7

[ArnulfKoch]

I would like to have the opposite: a more direct editing mode similar to MS Excel or MS Access, where you can edit the data much faster, easier and more directly.
This means no starting of the editing with ENTER and an automatic saving (without asking) when leaving the cell. With full support of arrow keys and tabulator.

[fifonik]

If implemented it should be optional as I like current program's behaviour.

[Ejsstiil]

Please don't do that.
And as @ArnulfKoch wrote i'd like exactly the same direct access

[lezhkin11]

This prevents me from using Heidi on production databases. Because you really can accidentally change data. For instance, copy from cell -> focus on other place by clicking -> paste, when doing things quickly you may end up with: copy -> paste -> click instead of copy -> click -> paste.
Would be nice to have an ability to control this behaviour.
I do like how it works now, but in production people need something safer.

[rgtc-antonio]

+1