On 11/11/06, Patrick Marchwiak <[EMAIL PROTECTED]> wrote:
I am working on a Java program that uses SQLite for its database. I am using auto increment on some of my inserts and am wondering if there is some easy way to retrieve the auto incremented rowid right after inserting. I realize that there is a C++ function that does just that , but googling did not turn up much for Java. Thanks.
You should be able to get the last inserted rowid using the last_insert_rowid() function in a query: SELECT last_insert_rowid(); ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------