Error updating more the one row

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
moppelstroppel
Posts: 17
Joined: Sat 25 Aug 2018 08:09

Error updating more the one row

Post by moppelstroppel » Thu 06 May 2021 14:01

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

moppelstroppel
Posts: 17
Joined: Sat 25 Aug 2018 08:09

Re: Error updating more the one row

Post by moppelstroppel » Thu 06 May 2021 14:51

Sorry my fault. A TRIGGER was the real problem.

ViktorV
Devart Team
Posts: 3041
Joined: Wed 30 Jul 2014 07:16

Re: Error updating more the one row

Post by ViktorV » Fri 07 May 2021 10:40

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

Post Reply