getting last insert id from SQLite autoincrement column

David Beck david_beck at
Wed Jul 11 14:06:36 EDT 2007

I have not been able to find out how to get the last insert id after 
inserting a record into a SQLite table with the PRIMARY KEY 
AUTOINCREMENT flags set. I'm sure I must be missing something? I have 
searched through SQLite docs and rev mailing lists to no avail. Can 
anybody shed some like on this issue? (LAST_INSERT_ID() does not seem to 
be implemented in SQLite.) Thanks in advance.


More information about the Use-livecode mailing list