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
--
View this message in context:
http://old.nabble.com/Multiple-WHENs-in-triggers-tp33407606p33407758.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users