The CREATE TRIGGER example shown in the INSTEAD OF page (
http://www.sqlite.org/lang_createtrigger.html#instead_of_trigger) is
misleading because it does not show the correct use of the INSTEAD OF
clause in the trigger statement, it actually misses this clause altogether:
Examples
Assuming that customer records are stored in the "customers" table, and
that order records are stored in the "orders" table, the following trigger
ensures that all associated orders are redirected when a customer changes
his or her address:
CREATE TRIGGER update_customer_address UPDATE OF address ON customers
BEGIN
UPDATE orders SET address = new.address WHERE customer_name = old.name;
END;
It should read:
CREATE TRIGGER update_customer_address *INSTEAD OF* UPDATE OF address
ON customers
--
Christian Hoehne
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
