Last inserted row id (SQLite)

[TheRawGod]

Hi guys!

I'm currently using SQLite through Poco::Data and am not sure how to _properly_ get the last inserted row id (autogenerated INTEGER PRIMARY KEY column value of the last inserted row).

SQLite C interface has a func for that but I couldnt' find anything in Poco as well as I couldn't find any suggestions in the forums or manuals.

I would appreciate any help or links.

PS I know that in most cases SELECT MAX(col_name) would do the job (just a little synchronization overhead would be required + this extra SELECT) but still that's not the _proper_ way I think. And that won't work in true 100% of cases :)

[alex]

SF tracker, item 1865864:

Code: Select all


int lastInsertID(Session& session)
{
    int id;
    session << "SELECT last_insert_rowid()", into(id), now;
    return id;
}


[TheRawGod]

alex,

thanks a lot. That couldn't be easier :)

PS Haven't looked in SF (:confused:), sorry.