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" <slurc...@yahoo.com.au>
To: <sqlite-users@sqlite.org>
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
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
