on duplicate key update --> Update failed: 2 Records found
Posted: Sun 19 Jul 2009 21:31
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
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