A weblog about programming in Python, C#, Java, Perl and C++ - and the occasional comment on PyCS development
new: discuss community servers on the CommunityServerWiki!
also available in XML
Copyright (c) 2002 Phillip Pearson
It's taken quite a while, but I finally know how to get the row ID of a row I insert into an Jet (Access) database. I'm used to MySQL, where SELECT LAST_INSERT_ID() returns the auto_increment value. It looks like Jet will give you the same results if you SELECT @@IDENTITY.
The process of finding information on software from Microsoft is new to me as I've used open-source tech (Apache, Perl, PHP, Python, MySQL, PostgreSQL) for pretty much all of my previous projects. It's interesting to compare the amount / quality of documentation between MS and non-MS solutions. In general I find that there is more documentation for the proprietary stuff, but I find it more difficult to find what I'm looking for, and often when I do find it, it's on a site like codeproject rather than in the official place.
It took me a few minutes to find last_insert_id() in the MySQL docs (when I'd only been using MySQL for a day or so), but I've been using System.Data for two weeks now and am only finding out important things like this now.
Can anybody point me at a better Windows data access reference? It seems that MSDN isn't as helpful as I was hoping.
Comment on this post [ so far]