How can I get last ID after inserting record?

Question

Given the following code:

 sqLiteDatabase.execSQL("create table if not exists ACCOUNT (ID integer primary key autoincrement," +
                        "CASH LONG NOT NULL," +
                        "BANKID INTEGER NOT NULL," +
                        "ACCOUNTNO TEXT ," +
                        "DATE TEXT NOT NULL," +
                        "COMMENT TEXT);");

A table is created in SQLite.

How can I get a lastID after adding a record?

With the following code:

 contentValues.put("CASH", accountTO.getCash());
 contentValues.put("DATA", DatePro.currentDate());
 contentValues.put("BANKID", accountTO.getBankID());
 contentValues.put("ACCOUNTNO", accountTO.getAccountNo());
 contentValues.put("COMMENT", accountTO.getComment());

 Long i = sqLiteDatabase.insert("ACCOUNT", null, contentValues);

I get -1.

possible duplicate of [Get last inserted value from sqlite database Android](http://stackoverflow.com/questions/4017903/get-last-inserted-value-from-sqlite-database-android) — Pankaj Kumar, Jun 14 '13 at 06:57
Column name `DATE` in `create table`, `DATA` in `contentValues`. Fix that first. — laalto, Jun 14 '13 at 08:22

score 6 · Accepted Answer · edited Nov 24 '17 at 17:50

6

public long insert (String table, String nullColumnHack, ContentValues values)

Returns the rowID of the newly inserted row, or -1 if an error occurred.

edited Nov 24 '17 at 17:50

A. Alencar

141
2
8

answered Jun 14 '13 at 07:00

JaveZh

184
3

How can I get last ID after inserting record?

1 Answers1