Devart Forums

I use this in SQLUpdate

REPLACE INTO abs
(pid, bid, wid, day1, day2, day3)
VALUES
(:id , :cbid, &cwid, :day1, :day2);

Id and cbid are from another table in qry.SQL.

It work if the record is new but give me an error if it is there!!!

I tried to use qry.debug.SQL directly to mysql and it runs fine!

This error means that editing of a single record, for example in DBGrid, causes updating more than one record in the database table. MyDAC prevents such updating. If you think that updating more than one record is correct in your case, you should set the StrictUpdate option of the MyQuery object to False.