CREATE TRIGGER [Before_Insertion_Task_on_Scheduler]
BEFORE INSERT
ON [Scheduler]
FOR EACH ROW
WHEN new.DiaHs_Inicio not between (old.DiaHs_Inicio and old.DiaHs_Fin);
--Insert into Scheduler
values(new.Id_Tarea,new.DiaHs_Inicio,new.DiaHs_Fin,new.Estado);

BEGIN
select RAISE (ROLLBACK,"El nuevo DiaHs_Inicio está programado para otra
tarea...");
END

When I run the trigger gives me error and do not know where the error is.
Thank you
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to