Zurück
-
Titel
Update on many-many relationship tables gives the error, "Dynamic SQL generation for the UpdateCo -
Beschreibung
When working in the Details Viewer, Data tab, trying to update a many to many relationship gives the following error:
" Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information."
This is a many to many relationship table that does not have a primary key (just foreign keys). If running a SQL that import/updates there is no error or problem. If importing from an Excel spreadsheets there is no error or problem. This is only an issue with updates done manually in the data grid.
,
Anmeldung erforderlich
Sie müssen sich anmelden und über einen gültigen Servicevertrag verfügen, um auf Premium-Wissensartikel zugreifen zu zu dürfen.