Subject Retreiving the ID of the last recird added.
Author steve_jupiter
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.