Ok, thanks. Should have looked at that. RBS
On Tue, Jan 30, 2018 at 3:12 PM, Hick Gunter <h...@scigames.at> wrote: > See http://sqlite.org/c3ref/last_insert_rowid.html > > "Some virtual table implementations may INSERT rows into rowid tables as > part of committing a transaction (e.g. to flush data accumulated in memory > to disk). In this case subsequent calls to this function return the rowid > associated with these internal INSERT operations, which leads to > unintuitive results. Virtual table implementations that do write to rowid > tables in this way can avoid this problem by restoring the original rowid > value using sqlite3_set_last_insert_rowid() before returning control to > the user." > > Or a virtual table implementation might support querying the last inserted > rowid directly... > > > -----Ursprüngliche Nachricht----- > Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > Im Auftrag von Bart Smissaert > Gesendet: Dienstag, 30. Jänner 2018 16:04 > An: General Discussion of SQLite Database <sqlite-users@mailinglists. > sqlite.org> > Betreff: [EXTERNAL] [sqlite] sqlite3_set_last_insert_rowid > > Just wonder what the possible use for this is. > > RBS > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > ___________________________________________ > Gunter Hick | Software Engineer | Scientific Games International GmbH | > Klitschgasse 2-4, A-1130 Vienna | FN 157284 a, HG Wien, DVR: 0430013 | (O) +43 > 1 80100 - 0 > > May be privileged. May be confidential. Please delete if not the addressee. > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
