On Wed, Feb 8, 2012 at 9:12 AM, Rob Richardson <rdrichard...@rad-con.com>wrote:
> > And is it possible to have a conditional statement? > > CREATE TRIGGER record_big_order AFTER INSERT ON orders > BEGIN > IF new.value > 1000000 THEN > INSERT INTO big_orders (customer_name, salesman_id, value) > VALUES (new.customer_name, new.salesman_id, new.value) > END IF; > END; > CREATE TRIGGER record_big_order AFTER INSERT ON orders WHEN new.value > 1000000 BEGIN INSERT INTO big_orders ...; END; See http://www.sqlite.org/lang_createtrigger.html > > Thank you very much. > > RobR > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
