Hello.
I wonder if there is a good way to get the id of the last inserted row.
I see that there is the LastInsertId property in TMySQLClient, but when you use the client as a global object (since i dont want to start a new connection for every object that communicates with the MySQL server) i cant be sure that the ID corresponds to the insert i did.
Wouldt it be better to have that property as a part of the result when doing a INSERT query…
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello.
I wonder if there is a good way to get the id of the last inserted row.
I see that there is the LastInsertId property in TMySQLClient, but when you use the client as a global object (since i dont want to start a new connection for every object that communicates with the MySQL server) i cant be sure that the ID corresponds to the insert i did.
Wouldt it be better to have that property as a part of the result when doing a INSERT query…
Hello,
if you have several threads, you could use critical sections.
G.