Re: [sqlite] problem trigger

thanks Simon, I´ll try later and then I´ll tell you 2014-10-28 17:11 GMT-03:00 Simon Slavin : > > On 28 Oct 2014, at 8:06pm, pablo Van wrote: > > > WHEN new.DiaHs_Inicio not between (old.DiaHs_Inicio and old.DiaHs_Fin) > > I do not think SQLite supports

Re: [sqlite] problem trigger

On Tue, Oct 28, 2014 at 4:11 PM, Simon Slavin wrote: > > On 28 Oct 2014, at 8:06pm, pablo Van wrote: > > > WHEN new.DiaHs_Inicio not between (old.DiaHs_Inicio and old.DiaHs_Fin) > > I do not think SQLite supports NOT BETWEEN. > It does. See

Re: [sqlite] problem trigger

On 28 Oct 2014, at 8:06pm, pablo Van wrote: > WHEN new.DiaHs_Inicio not between (old.DiaHs_Inicio and old.DiaHs_Fin) I do not think SQLite supports NOT BETWEEN. I would change it to something like WHEN (new.DiaHs_Inicio < old.DiaHs_Inicio) OR (new.DiaHs_Inicio >

[sqlite] problem trigger

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