getting last insert id from SQLite autoincrement column

[David Beck]

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