how to get last inserted row id in sqlite

Question

function insertToProject(cast, pName)
{
    db.execute('INSERT INTO project (cd, pn) VALUES (?,?)', cast, pName);
        var x = last_insert_rowid();
        return x;
}

I have been trying this using javascript in titanium appcelerator. Can anybody tell me what I am doing wrong?

thanks but I got it.. have to use - var x = db.lastInsertRowId; instead of last_insert_rowid(); — nitin, Jun 01 '12 at 01:37
I know, I'm just asking if there is any errors? What is the `x` value when you run your code? — , Jun 01 '12 at 01:38
line = 19; message = "Can't find variable: last_insert_rowid"; Earlier I was getting this error. Now I am getting the x as the last id being inserted. — nitin, Jun 01 '12 at 01:47

Midhun MP · Answer 1 · 2013-11-30T19:56:28.453

5

For this you can use the lastInsertRowId property of database object.

You can use like:

var x = db.lastInsertRowId;

lastInsertRowId

lastInsertRowId : Number

The identifier of the last populated row

Please check this link for more details : Titanium.Database.DB

edited Nov 30 '13 at 19:56

answered Dec 29 '12 at 11:02

Midhun MP

103,496
31
153
200

score 2 · Answer 2 · answered Dec 16 '16 at 11:27

You may also do:

  db.transaction(function(tx) {
      tx.executeSql("INSERT INTO project (cd, pn) VALUES (?,?)", cast, 
                function(tx, res) {
                    var id = res.insertId;
                });
      });

Thus, getting the result of the successful insert and then its property insertId

how to get last inserted row id in sqlite

2 Answers2

lastInsertRowId