> Does the BEGIN start a transaction? No. Triggers work inside transactions that called them.
Pavel On Fri, Oct 16, 2009 at 5:22 AM, Wenton Thomas <thomas.wen...@yahoo.com> wrote: > For example, > > > CREATE TRIGGER update_customer_address UPDATE OF address ON customers > BEGIN > UPDATE orders SET address = new.address WHERE customer_name = old.name; > END; > > when updating address ON customers, > then follow a BEGIN ...END statement. > Does the BEGIN start a transaction? > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
