StrataFrame Forum

Access AutoNumber Insert

http://forum.strataframe.net/Topic15372.aspx

By Crones - 4/3/2008

Ok... I'm having a major brainfart here... I could've sworn I saw a posting somewhere here talking about retrieving AutoNumber fields from an Access DB after an insert awhile back....



Anyways, how to I get the new AutoNumber value after adding (and saving) a BO? It keeps returning -1 on me...



Do I have to resort to executing a "SELECT @@IDENTITY" command to retrieve it?
By Trent L. Taylor - 4/4/2008

It was a good ol' fashioned bug...so it wasn't you...it was us BigGrin  I have attached an updated Base assembly for you to try.  We are going to be putting out a maintenance release pretty soon that will have this in it, but you can get a head start Smile
By Crones - 4/4/2008

Sweet! That did the trick.



Thanks!
By Trent L. Taylor - 4/4/2008

Cool....glad to hear it! Smile