SQLite how to get last "AUTO INCREMENT" value

blackman890 · 12-11-2006, 11:14 AM

Hello there, I have been programming for quite some time now (getting a little tired) and I have one question;

in SQLite you can set a column as INTEGER PRIMARY KEY and when inserting valus that contain nothing in this column, it will automatic set that value (kinda like AUTO INCREMENT in SQL);

However I would like to retreave that value the SQLite automatic made;
How is that possible?;

Sincerely = Jonatan;

paulsm4 · 12-11-2006, 01:22 PM

Hi -

According to this article, you should basically be able to do a "select" from SQLITE_SEQUENCE:

http://www.sqlite.org/autoinc.html

SUGGESTION:
1. Create a couple of temporary tables
2. Explicitly specify "AUTOINCREMENT" in your primary indexes for each
3. Check "SQLLITE_SEQUENCE", your new row's key, and its ROWID for the *first* entry in the table.
4. Add a few more rows, alternating between the temporary tables.
5. See what happens.

'Hope that helps .. PSM