search

MarkMpn / Sql4Cds

SQL 4 CDS core engine and XrmToolbox tool
MIT License
75 stars 22 forks source link

Feature Request: Allow for "updating" many-to-many intersect tables #361

Closed daryllabar closed 1 year ago

daryllabar commented 1 year ago

If you attempt to update a many-to-many intersect table, you get this error:

Cannot update many-to-many intersect entities: DELETE any unwanted records and then INSERT the correct values instead

Would be nice to either give the SQL to do the Insert and Delete, or just do it for the user.

MarkMpn commented 1 year ago

Good point, I should be able to remove this restriction in the next version.