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.
,
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center