Devart Forums

I'm using Query Builder in version 6.0.128 Professional Edition and getting the messages "Update operation affected 0 records due to possible concurrency violation."

Here's the query I'm using:

SELECT s.name, c.category FROM s LEFT JOIN c ON s.id = c.ID WHERE c.category IS NULL

When I select table c from the dropdown menu and try to enter a value, I get the error message. Can I not edit the data this way because I'm using the table in the query? If not, is there a way to do this?

We are currently reviewing the post you have submitted and will answer you as soon as possible.

We do not guarantee correct editing of the table in Data Editor if the SELECT query doesn't include the key fields of the modified table.

In your case, you have to include the s.ID or c.ID field depending on what table you are going to edit.

Please let us know if that solves the issue.