Questions tagged as 'trigger'

Tagged questions
2
answers

Triggers vs. Stored Procedures

After searching the internet I found several tutorials on the subject, but what is still unclear to me is when to use a trigger and when a stored procedure. Thank you very much for any possible guidance !!! Sincerely, Miguel Angel     
asked by 28.05.2017 / 18:23
3
answers

How to make a trigger that when data is inserted into a table delete a record from that table?

I am doing a trigger in mysql that deletes a record from a table and executes when data is inserted in that table I do it in the following way DELIMITER $$ CREATE TRIGGER 'comp01'.'ELiminar***' AFTER INSERT ON 'comp01'.'<ft_inv_slvta>...
asked by 13.05.2017 / 16:38
0
answers

Changes made directly in the bd are not seen in the front

I have a web app with angular in the front and java in the back, the database with mySQL, the thing is that when entering a record in a table, one trigger updates the field of another, it is a Boolean field. I mean, when inserting a data in t...
asked by 29.03.2017 / 17:44
1
answer

UPDATE with INNER JOIN in Mysql

I have this database schema for an electronic calendar. I have a table of events and one of equipment which is a many to many relationship. Once an event is deleted, I need to change the status of the equipment (eg, projector, notebook, point...
asked by 13.12.2016 / 14:49
1
answer

Delete record with same value in different column only once

Good morning, in a trigger for insert I need to delete all the records that have a value greater than 0 in vat and at the same time delete one that does not say vat of the same client and same rut. (Does not have primary key) EJ: Cliente...
asked by 23.03.2016 / 14:31
1
answer

jquery to make chain triger of alt + printpant then to dump image on canvas

I'm trying to create a button for bug reports: and I need to improve the code script to execute the following functions: button handler report error. trigger the alt + PrintScreen combo. read the clipboard image. convert the image to s...
asked by 13.11.2017 / 19:59
1
answer

how it works not for replication in the triggers

Hi, I'm trying to understand how the triggers work when you specify not for replication, if for example I have a trigger instead of update not for replication that works on a view and instead of updating that view what it does is up...
asked by 31.10.2017 / 17:21
1
answer

Trigger does not update the field

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_c...
asked by 14.07.2017 / 17:48
1
answer

can you help me generate a TRIGGER in BD ORACLE?

I have many doubts when creating TRIGGERS I have a table called delegations where I have the columns advance 1, advance 2 and advance 3 the only thing that I want that TRIGGER to do is that I register in another table "audit" the user that makes...
asked by 09.02.2017 / 18:18