On 26 Feb 2020, at 2:15pm, Dan Kennedy <danielk1...@gmail.com> wrote:
> A statement like the following creates a "BEFORE" trigger named "AFTER". Does > that explain things? > > CREATE TRIGGER AFTER INSERT ON t1 BEGIN > ... > END; > > I find I fall into this trap about once every 18 months... If only you knew someone with the power to make this generate SQLITE_MISUSE so that you, and other programmers, don't have this problem. Oh well. (Backward compatibility ? Do you think anyone who used the word AFTER really wants a BEFORE trigger ? More likely to be a bug they should know about.) _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
