what is the equivalent of LAST_INSERT_ID() in mx.ODBC ?
maxm at normik.dk
Thu Dec 20 16:43:58 CET 2001
I am trying out mx.ODBC in windows (connecting to an Acces DB), and I am
doing an insert where the key is auto-generated by access. Now how do I get
the key back?
I have tried "c.execute('SELECT LAST_INSERT_ID()')"
but gets a:
ProgrammingError: ('37000', -3102, "[Microsoft][ODBC Microsoft Access
Driver] Undefined function 'last_insert_id' in expression.", 4523)
So I guess that is not the right way.
Has anybody got an idea? Is it an odbc, mx.ODBC or simply an access problem
to find the right documentation??
I have searched the web, the db.api, newgroups etc. but nothing is showing
regards Max M
More information about the Python-list