Subject RE: [ib-support] Displaying auto-number value
Author Richard Pendered
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
Subject: [ib-support] Displaying auto-number value


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

To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to