a1rex <a1rex2...@yahoo.com> wrote: > Retraction. Mea Culpa. Back to square oneā¦ > The modified code did not write anything to the drive! But there was > no error message from the SQLITE.
Why should there be? You have a legal statement - essentially update notes set note=1 where id='note text'; The condition is not true for any row - but that's not in itself an error. > I will. But the problem highlighted by my mistake with indexes is not > with the prepared statement, > but extremely slow write to the drive. Make all your updates within a single transaction. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users