:auto-increment support for SQLite databases ?

Tim Showalter <tjs-8WfoLeasP/[email protected]> Thu, 03 Feb 2011 00:03:49 -0800
Newsgroups gmane.lisp.clsql.general
Message-ID <[email protected]>
Hi, I have a suggestion, but I'm not quite sure how to implement it.

I see :auto-increment works for MySQL databases only.  Is there any chance
it can be added for SQLite databases as well?  Unfortunately, the SQL query
has to be SELECT LAST_INSERT_ROWID() instead of LAST_INSERT_ID().  I don't
quite see the right way to do this, but just hacking the query in
oodml.lisp appears to work.

Thanks very much,

Tim