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

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)

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).

: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:

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.

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

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.
:(

Please read my above comment - data can be edited only in the Data tab.

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

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

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.

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)