Dennis Cote wrote:
Igor Tandetnik wrote:
SQLite does not support cascading triggers. Operations performed by a
trigger never cause other triggers to run.
This is not true. SQLite supports multiple triggers on the same event
(insert, update, or delete) on a single table and it fires all
triggers associated with any inserts, updates, or deletes that are
done by a trigger.
Ah, I see now I have confused cascading triggers and recursive triggers.
The former are supported, the latter are not. That is, an action in a
trigger may fire another trigger, but not the same trigger that is
currently running.
Sorry for misinformation.
Igor Tandetnik
