Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DELIMITER //
- CREATE TRIGGER TRG_FACTURA_ADD AFTER UPDATE
- ON FACTURA
- FOR EACH ROW
- BEGIN
- IF OLD.monto_resta <= 0 AND NEW.monto_resta > 0 THEN
- INSERT INTO bolsa_factura(id_bolsa, id_factura, fecha_telcel)(SELECT id_bolsa, id_factura, CURRENT_TIMESTAMP
- FROM historico_bolsa_factura
- WHERE id_factura = OLD.id_factura
- LIMIT 1);
- END IF;
- END;
- //
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement