distal-attribute
distal-attribute
distal-attribute
distal-attribute

Feature Suggestion

King Ilian posted 6 years ago in Feature discussion
I was wondering if it was a good idea to add the feature to edit the tables directly. Like select the database, select a table, select Data tab and just modify values from there, then hit a button "Save" or something similar and the GUI will run queries to modify those cells on the server.

Thanks

Ilian
ansgar posted 6 years ago
Hmm this sounds pretty exactly like it is implemented in HeidiSQL... Click a database, click a table and switch to data tab. Or how's that meant?
Dr. Dave posted 6 years ago
You can do that. However, there's only one caveat with direct editing; to have your edits applied, you must use either your up or down arrow key to select a next or previous row for your current row's changes to take place. Here's what I've discovered:

After entering data you:
TAB = no update
RETURN = no update
ENTER = no update
UP ARROW to previous row = UPDATES
DOWN ARROW to next row = UPDATES

Now... if you happen to keep TABbing to where it drops you to the next row, then it will update.

Oh, and another thing. If you enter data in a field and use your mouse to select a different row, you'll lose your changes. You must physically use your keyboard. Sucks, I know, but oh well, that's how it has to work.

I hope I didn't totally confuse you.
rosenfield posted 6 years ago

Dr. Dave wrote: If you enter data in a field and use your mouse to select a different row, you'll lose your changes.


Just tested in rev1590. That's not true.

(If it was, that would be a bug.)
Dr. Dave posted 6 years ago

rosenfield wrote:

Dr. Dave wrote: If you enter data in a field and use your mouse to select a different row, you'll lose your changes.


Just tested in rev1590. That's not true.

(If it was, that would be a bug.)



Changed data does indeed query correctly when using the mouse to select a different row. Thanks rosenfield for the correction.
Amenthes posted 6 years ago
Hi,

I was wondering if there's any setting to disable data updating when
navigating with the keys. I want to be able to update records only when
CTRL+Enter or clicking the POST button.

Thanks

P.S. Really nice work guys. I'm switching from MySQL Tools to HeidiSQL and
I'm very happy with it.
ansgar posted 6 years ago
There is no setting for that automatism currently. Not sure if that would make so much sense.

Please login to leave a reply, or register at first.