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)
Can't edit data in table - am I being stupid here?
: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:
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:
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.
:(
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
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
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.
Please login to leave a reply, or register at first.