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

Can't edit data in table - am I being stupid here?

User, date Message
Written by BillyD
5 years ago
Category: General
2 posts since Fri, 22 May 09
Hi there, have just installed this wonderful software and am finding it absolutely brilliant. There's just one odd thing, and I am sure it must be some mistake on my part...

When I am looking at the data in a table, it appears that I can edit the contents of a recordset. However, it doesn't seem to 'save'. (i.e. it doesn't actually update the table contents). Now am I just being dumb and missing something obvious? Or is it a more obscure issue of permissions somewhere or something? Or in fact is it not actually possible to alter data via the table data view, and I just have to bung in an UPDATE query instead?

(I did have a search around the forum but couldn't find an answer to this)
Written by ansgar
5 years ago
4801 posts since Fri, 07 Apr 06
The grid in the "Data" tab is meant to be edited - you should definitely see UPDATE queries in the bottom log after you left the edited records (by pressing Ctrl+Enter or moving with arrow keys to the above or below row).
Written by BillyD
5 years ago
2 posts since Fri, 22 May 09
:lol: :lol: :lol: :lol:

Yes, I WAS being stupid. Very stupid. I was simply moving to the field to the left or right, and then changing to another table and back again - and wondering why the changes hadn't saved. However, like you say, moving up or down to a different recordset, and the changes are 'saved' just fine.

Sorry... :oops:
Written by ansgar
5 years ago
4801 posts since Fri, 07 Apr 06

BillyD wrote: I was simply moving to the field to the left or right, and then changing to another table and back again - and wondering why the changes hadn't saved.



Oh that makes me think ... sounds like a bug - updates should get posted in such cases.
Written by Deej
5 years ago
2 posts since Tue, 09 Jun 09
Hi,

I'm using 4.0 and I can not seem to edit any fields in a result set. I put in a new value, hit return and it just reverts back to the old value.

Am I missing some type of save button or something?

Thanks
Written by primej
5 years ago
1 posts since Wed, 10 Jun 09

Deej wrote: Hi,

I'm using 4.0 and I can not seem to edit any fields in a result set. I put in a new value, hit return and it just reverts back to the old value.

Am I missing some type of save button or something?

Thanks



I have the same problem in V4.0.
Maybe you can only modify data in DATA and not in QUERY window. But if this is true we have some serious limitation, because you can't change data in returned query result set.
:(
Written by ansgar
5 years ago
4801 posts since Fri, 07 Apr 06
Please read my above comment - data can be edited only in the Data tab.
Written by Deej
5 years ago
2 posts since Tue, 09 Jun 09
Thats not so easy when you have 40,000 records spanning 50+ columns.unhappyOr you want to query two different records and make some columns identical by just having the two in a result set and walking down the columns, changing whats necessary. It would be a HUGE feature to be able to edit a result set.

Is there a plan for this feature in a future release? Please say yes! :o
Written by muzza4
5 years ago
51 posts since Mon, 04 Dec 06
Hi Deej,

I'm with you on this one.

My workaround is to drop the old version 3.2 heidisql (renamed) into the version 4 folder, and just use that when I have lots of updates.

It seems very happy there.

However, be careful with updating data from a query: make sure you have the indexes included in the code - "select *" is safest.

Cheers
Muzza
Written by ansgar
5 years ago
4801 posts since Fri, 07 Apr 06
See request #723 (Editable query results). But you won't be happy with that if you have complex queries - we will start by making simple "SELECT * FROM table" queries editable, while blocking various JOINs, to be able to implement a simple parser.
Written by x2A
5 years ago
14 posts since Fri, 22 May 09

Deej wrote: Thats not so easy when you have 40,000 records spanning 50+ columns.



It is! You use the Data tab, but apply a filter so it only shows you records you wanna see (for the fields you wanna see, in the order you wanna see)
 

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