Quoth Russell A <slurc...@yahoo.com.au>, on 2010-10-07 22:24:23 -0700: > 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?
Your answer is right in the docs, where the syntax diagrams at http://sqlite.org/lang_createtrigger.html will demonstrate that the body of a trigger is a sequence of UPDATE, INSERT, DELETE, and SELECT statements. There is no full procedural language. ---> Drake Wilson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
