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
