What about using a stored procedure instead of a trigger? The stored
procedure could return the generated value that was used to set the
identity column.

-----Original Message-----
From: hay77772000 [mailto:david.hay@...]
Sent: Monday, April 28, 2003 1:22 PM
To: ib-support@yahoogroups.com
Subject: [ib-support] Getting id of last inserted record


Hi. Am still continuing to port our system from mySQL to
Firebird.

Have set up the database correctly, along with generators and
triggers that simulate an autoincrement field.

However, I still need a way to get the id back of the record
just
inserted, in a distributed, multiple-user environment.

Can anyone let me know how to do so, please? I understand I
could
use SELECT GEN_ID(GEN_ATABLE, 0) FROM RDB$DATABASE; but that
this
cannot be relied on with other transactions etc..

Thanks,

David





Yahoo! Groups Sponsor

<http://rd.yahoo.com/M=229633.3212141.4526654.2595810/D=egroupweb/S=1705
115386:HM/A=1556779/R=0/*http://shop.store.yahoo.com/cgi-bin/clink?ftd2+
shopping:dmad/M=229633.3212141.4526654.2595810/D=egroupweb/S=1705115386:
HM/A=1556779/R=1/1051561355+http://us.rmi.yahoo.com/rmi/http://www.ftd.c
om/rmi-framed-url/http://www.ftd.com/yahoo36>

<http://us.adserver.yahoo.com/l?M=229633.3212141.4526654.2595810/D=egrou
pmail/S=:HM/A=1556779/rand=309980560>

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



Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]