Hello, On 2017-03-29 13:07, Hick Gunter wrote:
-----Ursprüngliche Nachricht----- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Cezary H. Noweta Gesendet: Mittwoch, 29. März 2017 12:37 An: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Betreff: Re: [sqlite] VT table behavior change between 3.10 and 3.17
[...] Why xOpen-ed cursor cannot be used to write to a table?
The xUpdate method alone is used to perform updates to virtual tables. It does not take a cursor argument.
Also, there is no method taking a cursor argument that allows data to be changed.
The documentation is correct in that UPDATE and DELETE queries involve reading from the table first, and xOpen will be called to do that. Pure INSERT queries don't even call xOpen.
Indeed, the sole place, where VOpen is used, is a processing of WHERE clauses (UPDATE, DELETE have a WHERE clause, while INSERT, REPLACE have not).
My questions concerned a connection between your first sentence (``According to the documentation...'') and the remaining part of your post. Now, I see that you have explained the behavior of SQLite rather then quoted the documentation. I'm sorry for OT disturbance.
-- best regards Cezary H. Noweta _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
