At 01:03 PM 21/02/2004 +0000, you wrote:

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

That's easy - because those other dbms don't support parallel updates that
don't need to pessimistically lock rows or even tables! In a fully
implemented, bomb-proof multi-user system, there is no such global concept
as "last-anything". All activity happens along a continuum, with arbitrary
"starts" and "finishes" isolated by transactions. Each transaction has its
own time-warp. :-)

It's been said before it seems to have escaped somewhere...if you want the
ID back into your application, GET IT BEFORE YOU POST.

In your app it's very easy to write a function - in Delphi components, some
provide functions to get any generator value automatically (bit it's a dead
easy function to write, whatever you use).

/hb