"jeffhg582003" <je**********@yahoo.com> wrote in
news:ma***************************************@pyt hon.org:
fields. I am trying to capture the number generated from the insert
but I am not exactly sure how to do that after an insert.
Other folks have pointed you to "select @@identity" but I thought I
should mention that if you use ADO with the AddNew method then
autonumbers are magically retrieved. Something like this should work:
rs.AddNew()
rs.Fields("somefield").Value= "Blah"
rs.Update()
print "Autonumber is", rs.Fields("TheAutonumberField").Value
This didn't always work so ADO and the MDB can't be ancient versions.
SQL Server will also do this but the recordset must be opened with:
rs.CursorLocation= constants.adUseServer
rs.Open("Tablename", conn, constants.adOpenKeyset,
constants.adLockOptimistic)