Can't edit data in table - am I being stupid here?
| User, date | Message |
|---|---|
|
Written by BillyD
4 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
4 years ago 3958 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
4 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
4 years ago 3958 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
4 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
4 years ago 1 posts since Wed, 10 Jun 09 |
Deej wrote: Hi, 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
4 years ago 3958 posts since Fri, 07 Apr 06 |
Please read my above comment - data can be edited only in the Data tab. |
|
Written by Deej
4 years ago 2 posts since Tue, 09 Jun 09 |
Thats not so easy when you have 40,000 records spanning 50+ columns. Or 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
4 years ago 50 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
4 years ago 3958 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
4 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. |