Page 1 of 1

Error updating more the one row

Posted: Thu 06 May 2021 14:01
by moppelstroppel
Hi support,

if I try to udpating more the one row I get the error
#42000Result consisted of more than one row
I'm using a
MySQL 8.0.19
MyDAC 10.4.03
C++Builder 10.3

I tried
- TMyQuery with StrictUpdate (true / false) and/or QuoteNames (true / false)
- TMyCommand
- TMyScript

Thanks
Thomas

Re: Error updating more the one row

Posted: Thu 06 May 2021 14:51
by moppelstroppel
Sorry my fault. A TRIGGER was the real problem.

Re: Error updating more the one row

Posted: Fri 07 May 2021 10:40
by ViktorV
Hi Thomas,

I’m glad that your issue is resolved and you can use all features of the software.
Please feel free to contact us anytime if you get any other questions in future.

Regards,
Viktor