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