on duplicate key update --> Update failed: 2 Records found

[mariusz]

Hello!

I have TMyQuery and TMyUpdateSQL. In the Update statment I'm using
"insert into table () values () on duplicate key update field = :xxx".

During insert, MySQL return 1 updated / inserted record but during update - 2 records. It raise my application error (like in the topic).

What can I do, to provide it?

best regards
Mariusz

[Dimon]

To solve the problem you should set the Options.StrictUpdate property to false.