With 5.1.0.3287 I'm able to edit views with more than 1 table, with 5.1.0.3344 I'm not able to edit

User, date Message
User: fabian
Posted: Thu, 27 May 10 21:14
Category: General
15 posts since Tue, 02 Mar 10 		Hello,

with 5.1.0.3287 I'm able to edit MySQL-views with more than 1 table, with 5.1.0.3344 I'm not able to edit this views.

Message: Grid editing error: More than one table involved.

How could I edit MySQL-views with more than 1 table again?

Thanks.

Fabian
User: anse
Posted: Thu, 27 May 10 22:40
1822 posts since Fri, 07 Apr 06 		Oh, that's too bad. I have heavily modified the internal logic of grid editing in a way that it fetches table name from incoming columns via MySQL API. Now you can also edit query results, which is fine I think. Didn't think of views returning the original table. Probably I can fix that by making some check for view/table, but that could easily be impossible. We'll see.
User: fabian
Posted: Fri, 28 May 10 09:18
15 posts since Tue, 02 Mar 10 		Thank you very much in advance...

Fabian
User: anse
Posted: Wed, 09 Jun 10 22:55
1822 posts since Fri, 07 Apr 06 		Was reported as issue #1999 in the meantime.
User: fabian
Posted: Fri, 11 Jun 10 12:01
15 posts since Tue, 02 Mar 10 		Thank you for this information.
User: anse
Posted: Sun, 20 Jun 10 19:01
1822 posts since Fri, 07 Apr 06 		Problem solved now. Please update your executable.
User: fabian
Posted: Sun, 20 Jun 10 21:21
15 posts since Tue, 02 Mar 10 		I updated, Message changed:

Grid editing error: Selected columns don't contain a sufficient set of key columns to allow editing. Please select primary or unique key columns, or just all columns.
User: anse
Posted: Sun, 20 Jun 10 21:40
1822 posts since Fri, 07 Apr 06 		Did you deselect one or more columns then?
User: fabian
Posted: Thu, 24 Jun 10 04:07
15 posts since Tue, 02 Mar 10 		Until now I changed not my views, because with 5.1.0.3287 all is fine.

It's usefull for you (development) if I change the views for tests?
User: anse
Posted: Thu, 24 Jun 10 08:15
1822 posts since Fri, 07 Apr 06 		What do you mean by "changing the views"?

Do you still get the above error message? Could you answer my above question?
User: fabian
Posted: Wed, 14 Jul 10 14:27
15 posts since Tue, 02 Mar 10 		Vorab entschuldige ich mich für die späte Antwort und dass ich in deutsch schreibe.

Mit "changing the views" meinte ich, dass ich die SQL-View (CREATE VIEW...) nicht verändert habe, da die SQL-View ja in der Version 5.1.0.3287 ohne Probleme zu editieren ist.

Ich habe gerade mal die neueste Version r3453 getestet und dort erscheint beim Versuch die SQL-View zu editieren die Meldung: "Grid editing error: Selected columns don't contain a sufficient set of key columns to allow editing. Please select primary or unique key columns, or just all columns."

Danke im Voraus.
User: anse
Posted: Wed, 14 Jul 10 15:59
1822 posts since Fri, 07 Apr 06 		Ja die Meldung hattest du vorher schon gepostet, aber die Antwort auf meine Frage nicht: Die VIEW selektiert offenbar nur einige der Tabellenspalten. In dem Fall kann man keine zuverlässigen UPDATEs und DELETEs auf dem View formulieren. Das ist der Grund für diese Fehlermedung - nichts was HeidiSQL beheben kann.
User: fabian
Posted: Wed, 14 Jul 10 16:26
15 posts since Tue, 02 Mar 10 		Nach Einbindung aller ID-Spalten der beteiligten Tabellen in der SQL-View ist ein Editieren wieder möglich. (-:

Besten Dank für Deinen Hinweis!

Mit dem Umstand, dass HeidiSQL in der Version r3287 nicht auf ID-Spalten Wert gelegt hat konnte ich bestens leben, aber so ist es nun sicherlich besser (Zitat: "In dem Fall kann man keine zuverlässigen UPDATEs und DELETEs auf dem View formulieren.").

Besten Dank für Deine immer sehr sehr sehr schnellen Antworten!
 

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