What you should do is to have a stored proc to do this,
first it should get the next number from the generator,
then insert record with params, and number got,
on the output param, send the number back.

-----Original Message-----
From: steve_jupiter [mailto:stephen@...]
Sent: 14 June 2002 16:27
To: ib-support@yahoogroups.com
Subject: [ib-support] Retreiving the ID of the last recird added.


Hi all,

I am trying to get the ID for the last record added to a table.

For example - when adding a record to a Customer table I use a
trigger to generate an integer ID number for that record. I then want
to get that number immediately.

Is there a function to do this ?

Thanks for any help.

Stephen.



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/