Hi Keith, Thanks for the reply.
On Mon, Dec 2, 2019 at 6:31 PM Keith Medcalf <kmedc...@dessus.com> wrote: > Well, of course the trigger did not fire. You created an AFTER UPDATE > trigger, but only did an insert. So of course one would not expect the > trigger to fire. You're right- this was a copy/paste error in my attempt to produce a brief example. > Also, the "of <columns> on <table>" refers to columns that YOU name in the > INSERT/UPDATE statement and does not include computed columns, since you do > not update them (you will get an error message telling you that you cannot > be doing that if you try to do that). This is very helpful. I had assumed the trigger would fire for any update of the column, computed or otherwise. Thanks again. Stephen _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
