[Lazarus] TSQLQuery: Getting autoincremented ID value after insert (MySQL)

[Reimar Grabowski]

On Thu, 13 Nov 2014 13:26:32 -0300
Marcos Douglas <md at delfire.net> wrote:

> Hi,
> Take a look in Greyhound project: https://github.com/mdbs99/Greyhound
I did and could not see how it helps.
 
> Here you can see an example using "last id":
> https://github.com/mdbs99/Greyhound/blob/master/test/ghsqltest.pas#L285
Yes, if you are using Greyhound, which I am not.

So it looks like there's nothing in TSQLQuery that does the job for me.
I now just use another TSQLQuery with the following SQL:

SELECT LAST_INSERT_ID() AS SomeNameIChoose;

Seems to work well, reduces the lines of code as I don't have to set parameters (my primary goal), can be reused for other inserts (being not table dependent) and took about 1 Minute to implement.

Thanks anyways.
R.