Page 1 of 1

AutoInc with MySQL 5.1 not working

Posted: Thu 12 Nov 2020 19:28
by moppelstroppel
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

Re: AutoInc with MySQL 5.1 not working

Posted: Mon 16 Nov 2020 09:03
by moppelstroppel
After upgrading to V8 the application is working as expected.

Re: AutoInc with MySQL 5.1 not working

Posted: Wed 18 Nov 2020 17:15
by ViktorV
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.