Get id from inserted row?

[Torben Philippsen]

Hello!

When inserting a new row into a database I was wondering if it is possible
to retrieve the id (key-field) for the new row - after insert ofcourse?

Thank You
Torben

 

[Cor Ligthert]

Torben,

When you search this newsgroup on @@identity you find a lot, this is an
answer from Selim

http://groups.google.com/groups?selm=#[email protected]

I hope this helps?

Cor

 

[Paul Clement]

¤ Hello!
¤
¤ When inserting a new row into a database I was wondering if it is possible
¤ to retrieve the id (key-field) for the new row - after insert ofcourse?

The method would depend upon the type of database (and version) you are using.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)