Devart Forums

Hello

When I do Edit, Post and there are more than 1 matching records I get Update Failed: xx records found exception. Which is correct.

But as I've noticed it still does the update. It still updates that xx records. What I think is not correct. And I did not notice this earlier.

Tell me what to do to show you.

Thanks.

MyDAC cannot determine how many records will be modified before an update query has been performed. After an update command has been performed, MyDAC gets from the server count of the affected rows, and, if the value differs from one, raises an exception. To avoid this problem, you should wrap delete and update operations in transactions.

I guess this does not matter if this is a TMyTable or TMyQuery component?

TMyTable is just a wrapper on TMyQuery, so there is no difference in this case.

I see.
Not a good news, but thanks anyway