Thank you for you reply, :) But I see the return errmsg is "unknown error" on sqlite3.6.23-1. What does it mean?
Kees Nuyt wrote: > > On Mon, 24 May 2010 01:27:05 -0700 (PDT), liubin liu > <7101...@sina.com> wrote: > > >> Doesn't update return wrong code while >> there isn't record in table? > > No. Your update tells SQLite to update all rows in the > selection. It did. In this case "all" meaning zero, but that > is not an error. Think of it as executing a mathematical set > function on an empty set. An set being empty is normal, not > an error. > >>Is it normal action? > > Yes. It's common in most if not all SQL database systems. > > The number of rows affected can be retrieved with the > sqlite3_changes() function. > http://www.sqlite.org/lang_corefunc.html > -- > ( Kees Nuyt > ) > c[_] > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://old.nabble.com/Doesn%27t-update-return-wrong-code-while-there-isn%27t-record-in-table--tp28654671p28663384.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users