Thank you very much for the help, it has solved my issue
and now I know what for 'old' and 'new' stand in triggers ....
Sincerely
Louis Jean-Richard
s my problem
On 25. 10. 13 20:19, Richard Hipp wrote:
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".
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users