--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
wrote:

> > In order to get the last inserted id I made this stored as a test:

[CUT]

> this makes no sense
> max(generator)???? There's no such thing as a maximum of a single

newly

> generated value
> just select the generator into your var

The hurry... in the code I wrote it was
SELECT GEN_ID(BLABLA,1) FROM "TABLE1"
only in the stored procedure version I posted the Max() version.

>
> But really now - why are you wanting the last inserted ID?
>
> Alan

Because ..ehm ... I love it :P

I would like to add it in other tables but not immediately.
In other dbms there is LAST_INSERT_ID() why Firebird don't have it?

Thanks for your help
IK