Re: [sqlite] Re: getting PRIMARY KEY of last inserted object ?

Fine, thanks a lot ! yvon

[sqlite] getting PRIMARY KEY of last inserted object ?

Hy all, when inserted a new row in a table, is there a mean to get the PRIMARY KEY of this last inserted row ? that's to say just after the INSERT INTO myTable... whitout a SELECT afterwards ? -- yvon

[sqlite] SQL logic error or missing database

Hey all, i've an SQLite 3 database coming from a mobile phone (e2831) which works well on the phone itself : BEGIN TRANSACTION; CREATE TABLE devicephonebook( UID INTEGER PRIMARY KEY AUTOINCREMENT ,lastName TEXT NOT NULL DEFAULT(''),firstName TEXT NOT NULL DEFAULT(''), lastChar INTEGER