asp 用ODBC 连接SQLITE,怎么获取刚插入记录的自增ID? [有关问题点数:100分]
asp 用ODBC 连接SQLITE,如何获取刚插入记录的自增ID? [问题点数:100分]
http://bbs.****.net/topics/390487024
------解决方案--------------------
last_insert_rowid()试试
The last_insert_rowid() function returns the ROWID of the last row insert from the database connection which invoked the function. The last_insert_rowid() SQL function is a wrapper around the sqlite3_last_insert_rowid() C/C++ interface function
------解决方案--------------------
应该支持啊。直接
select last_insert_rowid();
http://bbs.****.net/topics/390487024
------解决方案--------------------
last_insert_rowid()试试
The last_insert_rowid() function returns the ROWID of the last row insert from the database connection which invoked the function. The last_insert_rowid() SQL function is a wrapper around the sqlite3_last_insert_rowid() C/C++ interface function
------解决方案--------------------
应该支持啊。直接
select last_insert_rowid();