Return
-
Title
Update on many-many relationship tables gives the error, "Dynamic SQL generation for the UpdateCo -
Description
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.
,
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.