StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Access AutoNumber Insert

Access AutoNumber Insert

Crones — Fri, 04 Apr 2008 13:24:42 GMT

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?

RE: Access AutoNumber Insert

Trent L. Taylor — Fri, 04 Apr 2008 13:24:42 GMT

Cool....glad to hear it! :)

RE: Access AutoNumber Insert

Crones — Fri, 04 Apr 2008 10:24:35 GMT

Sweet! That did the trick.

Thanks!

RE: Access AutoNumber Insert

Trent L. Taylor — Fri, 04 Apr 2008 09:42:47 GMT

It was a good ol' fashioned bug...so it wasn't you...it was us :D 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 :)