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

Marcos Douglas md at delfire.net
Fri Nov 14 14:10:22 CET 2014


On Fri, Nov 14, 2014 at 10:05 AM, Reimar Grabowski <reimgrab at web.de> wrote:
> 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.

It has a code that working with auto-inc.

>> 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.

Yes, I use everyday. I'm the author. ;-)


> 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.

Best regards,
Marcos Douglas




More information about the Lazarus mailing list