On a field by field basis:

    CASE..WHEN [condition 1]..THEN [result 1]..WHEN [condition n]..THEN 
[result n]..ELSE..END

----- Original Message ----- 
From: "Russell A" <[email protected]>
To: <[email protected]>
Sent: Friday, October 08, 2010 01:24 a
Subject: [sqlite] Confitional IF in triggers


This may be a really dumb question, but I've searched and can't find an 
answer.
Do SQLite triggers support any conditional expressions, like IF, or is there 
only the WHEN statement? If the latter, does that mean that multiple 
conditions must be in separate triggers?
Any help appreciated.Stopgap.



_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users 

_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to