[sqlite] How complicated can trigger statements be?

[Rob Richardson]

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