On 2 Nov 2012, at 4:36pm, "Igor Tandetnik" <itandet...@mvps.org> wrote:
> If a statement inside a trigger fails, then the trigger's execution as a > whole fails, and then the statement that caused the trigger to run in the > first place fails and reports the original error. Thus, if the two INSERT's > are in the trigger, and the first one fails, the second one doesn't even run. For clarity: if a statement inside a trigger fails, then the trigger's execution as a whole fails /immediately/. Execution stops with the first failure. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
