Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
AutoNumber
Yes , I found out that you can retrieve the value of the IDENTITY variable by using the INSERT method and it gives you the most recently used IDENTITY value for the current connection. This must be the way to do it because the book that I'm getting this information from also states the following...- gmariog
- Post #4
- Forum: Microsoft SQL Server: Programming
-
AutoNumber
Does anyone know why I can retrieve the value of an AutoNumber field in Access before updating the recordset, but I can't do the same in SQL server. Example: ************************ In Access this works: rs.AddNew iID = rs.Fields("ID") '*** AutoNumber field rs.update...- gmariog
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Programming
-
AutoNumber
Does anyone know why I can retrieve the value of an AutoNumber field in Access before updating the recordset, but I can't do the same in SQL server. Example: ************************ In Access this works: rs.AddNew iID = rs.Fields("ID") '*** AutoNumber field rs.update...- gmariog
- Thread
- Replies: 0
- Forum: Visual Basic (Classic)
