AutoInc with MySQL 5.1 not working
Posted: 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
UnicodeString id = q->FieldByName("n_id")->AsString;
id is empty.
Thanks
Thomas
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)
id is empty.
Thanks
Thomas