Cannot Delete, Modify Rows in the Query Window
This Bug is similar to FDBK20383 except that it occurs when there are no duplicate rows.
When trying to update a field or delete a row in the query window I get the message:
No row was updated.
The data in row 2 was not commited.
Error Source: Microsoft.VisualStudio.DataTools.
Error Message: The row value(s) updated or deleted either do not make the row unique or they alter multiple rows(2 rows).
Correct the errors and retry or press ESC to cancel the change(s).
When the desired action is performed by typing the SQL Statement then the desired result is acheived. ie: if I type Update Table a set field3 = 'xx' then it will work, just won't let me do it in the window.