On Fri, Nov 14, 2014 at 10:05 AM, Reimar Grabowski <[email protected]> wrote: > On Thu, 13 Nov 2014 13:26:32 -0300 > Marcos Douglas <[email protected]> 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 -- _______________________________________________ Lazarus mailing list [email protected] http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
