Re: [sqlite] virtual table end of insert

2013-09-11 Thread Simon Slavin
On 12 Sep 2013, at 1:27am, Simon Slavin wrote: > I suspect that in your place I would explicitly execute BEGIN and COMMIT, and > use xCommit to tell that the update was finished. Sorry, in case it's not obvious, ignore what I wrote and do whatever Dr Hipp wrote. He knows much better than I.

Re: [sqlite] virtual table end of insert

2013-09-11 Thread Simon Slavin
On 12 Sep 2013, at 1:16am, E. Timothy Uy 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

Re: [sqlite] virtual table end of insert

2013-09-11 Thread Richard Hipp
On Wed, Sep 11, 2013 at 8:16 PM, E. Timothy Uy wrote: > In a virtual table, an insert of multiple rows calls xUpdate multiple > times. How can I tell when the entire insert is complete? > I think the xRelease method of the virtual table object gets called when the statement finishes. > > e.g.,

[sqlite] virtual table end of insert

2013-09-11 Thread E. Timothy Uy
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