Ah, Ha! I got it to work. Thanks for your help. -----Original Message----- From: Igor Tandetnik [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 24, 2006 5:31 PM To: SQLite Subject: [sqlite] Re: Re: Insert triggers
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
