On Mon, 15 Nov 2010 15:15:10 +0300, Ruslan Mullakhmetov <r.mullakhme...@tools4brokers.com> wrote:
>hi. > >i need to get last insert id in multithreaded app. >I use C API, actually some C++ wrap over it. >if i execute query like " insert into tbl( filed ) VALUES ( 1 ); Select >last_insert_rowid() as li;" would be it atomic? or it anyway would suffer >from threads? The last_insert_rowid() function returns the ROWID of the last row insert from the database connection which invoked the function. So, yes, it suffers from threads if the threads use the same database connection. -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users