David Blake wrote:
> CREATE TRIGGER my_update_trigger BEFORE UPDATE ON My_table
> FOR EACH ROW WHEN NEW.lastupdated < OLD. lastupdated
> BEGIN
> UPDATE song SET 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
