R
Robin Lawrie
Hi,
Looking for some help here!
I'm adding records to a SQL 2000 DB using the objRS.AddNew and objRS.Update
methods.
What I'd like to do is determine the new primary key value of the added
record.
I've tried the suggestions here :
http://authors.aspalliance.com/remas/VFAQ/IdentityColumn/ and here:
http://support.microsoft.com/default.aspx/kb/221931 but none of them work
reliably. The Microsoft method worked a couple of times then kept reporting
the same Primary Key ID back to me then reported an old Primary Key.
I've spent a couple of hours on this which is ridiculous as this must be a
common thing to do.
Any suggestions / proven code very, very welcome!
Thanks in advance,
Robin.
Looking for some help here!
I'm adding records to a SQL 2000 DB using the objRS.AddNew and objRS.Update
methods.
What I'd like to do is determine the new primary key value of the added
record.
I've tried the suggestions here :
http://authors.aspalliance.com/remas/VFAQ/IdentityColumn/ and here:
http://support.microsoft.com/default.aspx/kb/221931 but none of them work
reliably. The Microsoft method worked a couple of times then kept reporting
the same Primary Key ID back to me then reported an old Primary Key.
I've spent a couple of hours on this which is ridiculous as this must be a
common thing to do.
Any suggestions / proven code very, very welcome!
Thanks in advance,
Robin.