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 < [email protected]> 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
