On 01/08/2011 08:12 AM, 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 ... > BEGIN > UPDATE SET NEW.somecol = (<expression to normalize NEW.somecol>); > END; > > I must write: > > CREATE TRIGGER ... > BEGIN > UPDATE<table> SET somecol = (<expression to normalize NEW.somecol>) > WHERE rowid = NEW.rowid; > END;
Something like this perhaps: CREATE TRIGGER sometrig AFTER UPDATE WHEN somecol != <expression> BEGIN UPDATE sometab SET somecol = <expression> WHERE rowid = NEW.rowid; END; _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users