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

Feature Suggestion

User, date Message
Written by King Ilian
6 years ago
Category: Feature discussion
1 posts since Fri, 18 Jul 08
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
Written by ansgar
6 years ago
5015 posts since Fri, 07 Apr 06
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?
Written by Dr. DaveMoney, Euro
6 years ago
105 posts since Sun, 27 Jan 08
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.
Written by rosenfield
6 years ago
127 posts since Wed, 24 Jan 07

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.)
Written by Dr. DaveMoney, Euro
6 years ago
105 posts since Sun, 27 Jan 08

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.
Written by Amenthes
6 years ago
2 posts since Wed, 21 Jan 09
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.
Written by ansgar
6 years ago
5015 posts since Fri, 07 Apr 06
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.