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 — Pankaj Kumar
– Pankaj Kumar, Commented Jun 14, 2013 at 6:57
Column name DATE in create table, DATA in contentValues. Fix that first. — laalto
– laalto, Commented Jun 14, 2013 at 8:22

A. Alencar · Accepted Answer · 2017-11-24 17:50:39Z

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

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

Collectives™ on Stack Overflow

How can I get last ID after inserting record?

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related