The only safe way to do it in a C/S world is via a stored proc:

CREATE PROCEDURE GetNextGen RETURNS (NextGenValue INTEGER) AS
BEGIN
NextGenValue = GEN_ID(GenName,1);
END;

Regards,
Andrew Ferguson
-- Every time you click an ad an angel gets its wings.

--- In ib-support@y..., "arnorog" <arno.rog@p...> wrote:
> Hello,
>
> I am a newby to Firebird.
>
> I would like to display the (generatied) value of an auto-number
> field (I've got auto-numbering working just fine).
>
> In MySQL there is a 'LAST_INSERT_ID()' function for this.
>
> How can I achieve this in Firebird/IB?
>
> Thanks in advance,
>
> Arno Rog
> Amsterdam