On 28 Apr 2013, at 3:02pm, Paolo Bolzoni <paolo.bolzoni.br...@gmail.com> wrote:
> And it seems quite an improvement, alas now I get this error: "cannot > open indexed column for writing." You have a column of type BLOB. It is now an indexed column. You are trying to use the BLOB editing routines to write into that BLOB rather than just replacing the value in one operation. SQLite won't let you open an indexed BLOB value in editing mode because it doesn't know what you want the index to reflect while the value is being edited. You can replace the BLOB value in a single operation (using UPDATE). Or you can remove any index from that column. Sorry. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users