getting last insert id from SQLite autoincrement column
Trevor DeVore
lists at mangomultimedia.com
Wed Jul 11 14:25:17 EDT 2007
On Jul 11, 2007, at 2:06 PM, David Beck wrote:
>
> 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.
For SQLite you can execute the following query using revDataFromQuery
to get the last inserted id:
SELECT last_insert_rowid()
--
Trevor DeVore
Blue Mango Learning Systems
www.bluemangolearning.com - www.screensteps.com
trevor at bluemangolearning.com
More information about the use-livecode
mailing list