On Fri, Oct 25, 2013 at 2:10 PM, Louis Jean-Richard <
l_jean_rich...@bluewin.ch> wrote:

> CREATE TRIGGER atable_updated AFTER UPDATE ON atable
> FOR EACH ROW WHEN last_update != date('now') ....
>

I think you meant to say "old.last_update" instead of just "last_update".


-- 
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to