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

Reply via email to