AutoInc with MySQL 5.1 not working

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: 7
Joined: Sat 25 Aug 2018 08:09

AutoInc with MySQL 5.1 not working

Post by moppelstroppel » Thu 12 Nov 2020 19:28

Hello support,

I have a problem at customer site. Thye are uisng database MySQL 5.1.
I cannot reproduce in my system with MySQL 8.1.

Is the problem existing with MySQL 5.1 and AutoInc value after INSERT command?

TMyQuery with "Update SQLs" page I defined

Code: Select all

INSERT INTO &MainTableName
  (n_id, c_nr)
VALUES
  (:n_id, :c_nr)
UnicodeString id = q->FieldByName("n_id")->AsString;

id is empty.

Thanks
Thomas

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

Re: AutoInc with MySQL 5.1 not working

Post by moppelstroppel » Mon 16 Nov 2020 09:03

After upgrading to V8 the application is working as expected.

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

Re: AutoInc with MySQL 5.1 not working

Post by ViktorV » Wed 18 Nov 2020 17:15

Thank you for the interest to our product.
It is good to see that the issue has been solved.
If you have any questions during using our products, please don't hesitate to contact us - and we will try to help you solve them.

Post Reply