[sqlite] DxuxRe: SQLite IN operator on a Tcl list

[Pablo Van Mechelen]

Zd
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Library routine called out of sequence

[pablo Van]

I have a problem with my delphi's application when I want run it on other
PC. I use ZeosLib in my application
The message is : Library routine  called out of sequence
How I can fix it?
I need help urgent!!! please
Thanks at all
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] problem trigger

[pablo Van]

thanks Simon, I´ll try later and then I´ll tell you

2014-10-28 17:11 GMT-03:00 Simon Slavin <slav...@bigfraud.org>:

>
> On 28 Oct 2014, at 8:06pm, pablo Van <pdvm2...@gmail.com> 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.
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] problem trigger

[pablo Van]

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