System.Data.SQLite

Maybe im just braindead but the following does not work:
// create a connection & insert command
        SQLiteCommand IDCmd = new SQLiteCommand("Select sqlite_last_insert_rowid();", conn);
       
        try {
            conn.Open();
            cmd.ExecuteNonQuery();
            p.PrimaryKey = IDCmd.ExecuteScalar();
        }
        finally {
            conn.Close();
            conn.Dispose();
        }

it throws an error:
System.Data.SQLite.SQLiteException: SQLite error
no such function: sqlite_last_insert_rowid

on the line highlighted in red.  what exactly am I doing wrong?

Try SELECT last_insert_rowid(); instead :)

Robert

 

doh!  I figured this out about 5 minutes later and forgot to say I did.

Just a guess, but try

SQLiteCommand IDCmd = new SQLiteCommand("Select last_insert_rowid();", conn);

Oops. I only saw the first post, not the entire thread....