On 14 Nov 2012, at 2:58pm, Daniel Polski <[email protected]> wrote:
> If I have a value in a table, and use INSERT OR REPLACE to update the value, > a trigger created with AFTER UPDATE ON won't fire. Shouldn't an INSERT OR > REPLACE to a table which already contain data which are beeing replaced be > considered an "update" of the table? No. INSERT OR REPLACE does an INSERT, possibly after doing a DELETE. It never does an UPDATE. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
