>> SQLite does none of those. Have your program print out the actual command it’s trying to execute. Then try typing it manually. See if it works when you type it by hand.
Yes, I manually type all the command, also I check all the records I wanna delete by SELECT with the same where clause. Here are the scripts. schema: <http://sqlite.1065341.n5.nabble.com/file/t8403/schema.jpg> delete/insert operations: <http://sqlite.1065341.n5.nabble.com/file/t8403/delete.jpg> -- Sent from: http://sqlite.1065341.n5.nabble.com/ _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users