The example of a CREATE TRIGGER statement from the help page is:
CREATE TRIGGER update_customer_address UPDATE OF address ON customers
BEGIN
UPDATE orders SET address = new.address WHERE customer_name = old.name;
END;
The use of BEGIN and END to wrap the statement leads me to believe that it's
possible to have more than one statement between them:
CREATE TRIGGER update_customer_address UPDATE OF address ON customers
BEGIN
UPDATE orders SET address = new.address WHERE customer_name = old.name;
INSERT INTO orders_history (customer_name, address) VALUES
(old.customer_name, old.address);
END;
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;
Thank you very much.
RobR
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
