retreive last inserted record

[oliver voegeli]

hi!

is it possible to retrieve the last row which was inserted?

e.g., I insert a record like this:

"INSERT INTO SONG (Songtitle) VALUES ('purple rain');"

what I need then is the ID (fieldname: sID) of that record, I could retreive it like this:

"SELECT sID FROM SONG WHERE Songtitle = 'purple rain';"

is there a saver method? I mean, no matter what reasons, 'purple rain' could already exist in another record, then I might get the wrong sID...

oliver