Does SQLite support SCOPE_IDENTITY?

Question

I'm trying to perform a simple INSERT and return the identity (auto-incrementing primary key). I've tried

cmd.CommandText = "INSERT INTO Prototype ( ParentID ) VALUES ( NULL ); SELECT SCOPE_IDENTITY();";

and I receive the following error

EnvironmentError: SQLite error
no such function: SCOPE_IDENTITY

Does SQLite support SCOPE_IDENTITY?
If so, how do I use it?
If not, what are my (preferably "thread-safe") alternatives?

Answer 1

Check out the FAQ. The sqlite3_last_insert_rowid() function will do it. Careful of triggers though.

Answer 2

If you're not using the C interface for programming and want to do the process from an SQL Command try: SELECT last_insert_rowid()

http://www.sqlite.org/lang_corefunc.html