1
I am with the following doubt:
I have the table:
Escala
Data_Atuacao_Inicial, Data_Atuacao_Final, tipo
The guy can be 1 or 2
I want to create a Rigger to stop the Insert or update of this table, if I insert a scale or edit an existing one and put a date between the limits of another existing in the bank prevent and return a message.
Example:
Escala
Data_Atuacao_Inicial = 09-10-2019
Data_Atuacao_Final = 10-10-2019
tipo = 1
When I try inserir
or editar
another scale and place the dates between 09-10-2019 and 10-10-2019 and being type 1 should prevent(Instead off) and give a message (There is already a scale of type 1 acting on that date)
Can you help me?
I think the question has nothing to do with the c tag#
– João Paulo Amorim