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 NOT BETWEEN. I would change it to > somet

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 https://www.sqlite.org/lang_expr.html However Pablo

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 > old.DiaHs_Fin) Simon. ___