Albert Leibbrandt wrote: > > jeffhg582003 wrote: > > >>Hi, >> >>I am developing a python script which add records to >>a microsoft access tables. All my tables have autogenerated number >>fields. I am trying to capture the number generated from the insert but >>I am not exactly sure how to do that after an insert. >> > I had to do something similiar in sql server and the experts back then > told me that the only way is to write a stored procedure. aparently sql > server does not have sequences and I am guessing that access is the same. > Well the experts were wrong, I suspect. Try
SELECT @@IDENTITY to return the autonumber key created by the most recent INSERT. I believe this works for both SQL Server and Access (doesn't anyone use Google any more?). regards Steve -- Steve Holden +44 150 684 7255 +1 800 494 3119 Holden Web LLC www.holdenweb.com PyCon TX 2006 www.python.org/pycon/ -- http://mail.python.org/mailman/listinfo/python-list
