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 :)