Subject | Retreiving the ID of the last recird added. |
---|---|
Author | steve_jupiter |
Post date | 2002-06-14T15:27:27Z |
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.
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.