On 8 Jan 2011, at 1:12am, Nicolas Williams wrote: > I need to use recursive triggers. In some cases I want to "normalize" > values of some columns of NEW being INSERTed or UPDATEd, but there's no > UPDATE syntax for changing NEW, thus I can't write something like:
CREATE TRIGGER fred INSTEAD OF INSERT ON myTable ... See http://www.sqlite.org/lang_createtrigger.html Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users