Trigger does not update the field

Navigation
-1

Greetings friend I created a Trigger but it does not update me, what I would like to achieve is the following when you make an insertion in the advance table I update the amount that is in the table transvalue example if in amount_trans_values_current I have 20 and I make an insersion in the table in advance of 7 in the table transvalues I should stay 13

Advances table (ticket_code, amount, percentage, profit, total, id_points, date, time, user_id)

Transvalues table (amount_of_aperture_values, amount_of_current_values, date, names and surname 

CREATE 
TRIGGER nuevotrasvalor AFTER INSERT 
ON adelantos
FOR EACH ROW 
UPDATE trasvalores SET monto_trasvalores_actual = (monto_trasvalores_actual-
NEW.monto) 
WHERE monto_trasvalores_actual = NEW.monto_trasvalores_actual
    
asked by yoclens 14.07.2017 в 17:48
source

1 answer

-1

the solution was this: 

UPDATE trasvalores SET monto_trasvalores_actual = (monto_trasvalores_actual-NEW.monto)
    
answered by 14.07.2017 в 18:52
Add an item of a spinner inside a table and show information of spinners depending on one previously selected Do you know any Bundle to use datepicker in Symfony 3?