How To Return Record Number From AddNew
- From: "Jeff Gaines" <whitedragon@xxxxxxxxxxxxxxxxx>
- Date: Mon, 27 Aug 2007 01:59:30 -0700
I am sure I used to know how to do this but I can't find it in my notes :-(
After adding a record to an Access Database (programmatically using C#) I need to know the record number. The code snippet is:
adCON.Open(strConnection, "", "", 0);
adRS.Open(strQuery, adCON, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, 0);
if (adRS.EOF)
adRS.AddNew(fList, fValues);
else
adRS.Update(fList, fValues);
Is it possible to know what record number has been allocated by the Autonumber field? I know it before I call the function when updating a record but it is freshly allocated by Access for AddNew.
--
Jeff Gaines
.
- Follow-Ups:
- Re: How To Return Record Number From AddNew
- From: Bob Barrows [MVP]
- Re: How To Return Record Number From AddNew
- Prev by Date: Re: Delete a single record instead of entire recordset
- Next by Date: Re: How To Return Record Number From AddNew
- Previous by thread: Delete a single record instead of entire recordset
- Next by thread: Re: How To Return Record Number From AddNew
- Index(es):