Does SQLite support SCOPE_IDENTITY?
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?
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()