Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 How can I always retrieve last ID added

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-10-11 : 14:04:34
Brian writes "If I use and ID autonumber as a primary key, in ASP I can mostly retrieve the ID of the last record added by looking at .Fields("ID") after .update.
I understand there are circumstances when I can't do this (Professional Active Server Pages 3 - Wrox p346). Is there a method that will work every time?"
   

- Advertisement -