select gen_id( generator_name, 0 ) from rdb$database
should work for you....

-----Original Message-----
From: arnorog [mailto:arno.rog@...]
Sent: 29 July 2002 09:55
To: ib-support@yahoogroups.com
Subject: [ib-support] Displaying auto-number value


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



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/