getting last insert id from SQLite autoincrement column

David Beck david_beck at ministerschedulerpro.com
Wed Jul 11 13:06:36 CDT 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.

David



More information about the use-livecode mailing list