Ok thanks!
Simon Slavin skrev 2012-11-14 16:04:
On 14 Nov 2012, at 2:58pm, Daniel Polski <dan...@agelektronik.se> 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
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
