Is there a simple way to get the integer primary key of a new record inserted in a SQLite table

Shao Sean shaosean at wehostmacs.com
Mon Oct 27 06:03:22 EDT 2008

Previous message (by thread): Is there a simple way to get the integer primary key of a new record inserted in a SQLite table
Next message (by thread): Is there a simple way to get the integer primary key of a new record inserted in a SQLite table
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Apparently SQLite uses the following command but I have not tested it  
as of yet

SELECT LAST_INSERT_ROWID()

Previous message (by thread): Is there a simple way to get the integer primary key of a new record inserted in a SQLite table
Next message (by thread): Is there a simple way to get the integer primary key of a new record inserted in a SQLite table
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

More information about the use-livecode mailing list