Access AutoNumber Insert
 
Home My Account Forum Try It! Buy It!
About Contact Us Site Map
StrataFrame Forum
Home      Members   Calendar   Who's On
Welcome Guest ( Login | Register )
      



Access AutoNumber InsertExpand / Collapse
Author
Message
Posted 04/04/2008 12:11:24 AM
StrataFrame Beginner

StrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame Beginner

Group: StrataFrame Users
Last Login: Yesterday @ 8:49:49 AM
Posts: 30, Visits: 269
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?
Post #15372
Posted 04/04/2008 9:42:47 AM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: Today @ 11:13:06 AM
Posts: 4,104, Visits: 4,176
It was a good ol' fashioned bug...so it wasn't you...it was us   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

  Post Attachments 
MicroFourStrataFrameBase.zip (6 views, 490.46 KB)
Post #15378
Posted 04/04/2008 10:24:35 AM
StrataFrame Beginner

StrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame Beginner

Group: StrataFrame Users
Last Login: Yesterday @ 8:49:49 AM
Posts: 30, Visits: 269
Sweet! That did the trick.

Thanks!
Post #15380
Posted 04/04/2008 1:24:42 PM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: Today @ 11:13:06 AM
Posts: 4,104, Visits: 4,176
Cool....glad to hear it!
Post #15381
« Prev Topic | Next Topic »


Reading This TopicExpand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: Ben Chase, Trent L. Taylor, Steve L. Taylor

PermissionsExpand / Collapse

All times are GMT -6:00, Time now is 4:15pm

Powered By InstantForum.NET v4.1.4 © 2008
Execution: 0.062. 11 queries. Compression Enabled.
Site Map - Home - My Account - Forum - About Us - Contact Us - Try It - Buy It

Microsoft, Visual Studio, and the Visual Studio logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.