Ivan Shmakov <oneing...@gmail.com> wrote: > ACK, thanks. However, I'm not really interested in the result > of the first INSERT, and, in this case, these commands may > actually be a part of a trigger (where, I believe, I cannot look > at the result returned all that easily.)
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. Note that ending up in the IGNORE branch of INSERT OR IGNORE statement doesn't constitute failure, but normal execution. The same is true for INSERT ... SELECT statement where SELECT returns zero rows so nothing is actually inserted. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
