WARNING: This server is unstable and will be retired in the next days. If you want to keep this forum available, please request immediately a migration on the Nabble Support forum. Forums that don't receive any migration request will be deleted forever.

SQLite

« Return to Thread: Multiple WHENs in triggers

Re: Multiple WHENs in triggers

by hsymington :: Rate this Message:

| View in Thread

Pavel Ivanov-2 wrote:

>SQLite allows only one WHEN per trigger but any number of triggers per
>action (without any defined order of execution). So you can do it like
>this:

Thanks, Pavel, that's just what I needed to know. I think I'd been got by other languages only allowing one trigger per type.

Hamish

« Return to Thread: Multiple WHENs in triggers