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.
,
No primary key means a unique index needs to be defined. Toad should just set this if the grid is set to editable and there are no primary keys, but is currently not doing this.
WORKAROUND:
In the grid, go to the lower left corner. There is a round green or red button. Click on the little drop down button to the immediate right of that and in the menu that pops down. Choose "Define Custom Editing...". When the Custom Editing window pops up define a unique index manually. Click Ok to apply to the data grid and now it should be editable without any errors.
STATUS:
Waiting for fix in a future version of Toad for Data Analysts.
This applies to any data grid window in TDA. This may apply to various platforms.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center