Thanks for such a swift reply, good to know that it should work (without
typos)
>Thank you very much for keeping the error message secret.
near "END": syntax error:
I'm testing out ideas using DB Browser, but will try in my app and see if
this is just a DB Browser issue
On Thu, 12 Mar 2020 at 08:04, Clemens Ladisch <clem...@ladisch.de> wrote:
> David Blake wrote:
> > CREATE TRIGGER my_update_trigger BEFORE UPDATE ON My_table
> > FOR EACH ROW WHEN NEW.lastupdated < OLD. lastupdated
> > BEGIN
> > UPDATE my_tableSET lastupdated = DATETIME('now') WHERE id = NEW.id
> > END
> >
> > The WHEN clause is an attempt to avoid infinite recursion that UPDATE
> > within an UPDATE would cause.
>
> Typical UPDATE statements will leave this field with its old value, so
> it might be a better ideas to use <= instead of <.
>
> > However I get SQL errors when I try defining a trigger this way this
> > in my favorite db dbrowser.
>
> Thank you very much for keeping the error message secret.
>
> When I fix the wrong table table name and add the missing semicolon after
> the UPDATE statement, this trigger works fine.
>
>
> Regards,
> Clemens
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
