On 12 Sep 2013, at 1:16am, E. Timothy Uy <t...@loqu8.com> wrote: > In a virtual table, an insert of multiple rows calls xUpdate multiple > times. How can I tell when the entire insert is complete? > > e.g., > INSERT INTO myvirtualtable (token, rank) VALUES (..,..), (..,..),(..,..) > > will call xUpdate 3 times. But I would like to know when the whole thing is > done so that I can do something....
Does SQLite always call xBegin and xCommit even if you execute UPDATE without explicit BEGIN and COMMIT commands ? No, the documentation suggests it doesn't (but I may have misinterpreted). > or is my only option sending a command? I suspect that in your place I would explicitly execute BEGIN and COMMIT, and use xCommit to tell that the update was finished. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
