On Sun, Dec 23, 2012 at 2:51 PM, Patrik Nilsson
<nipatriknils...@gmail.com>wrote:
> Hi All!
>
> When I perform a select as the following
>
> select * from repetition where interval>0 and id=617
>
> the result is unexpected
>
> 617|2012-12-23 19:30:46|0|2012-12-23 19:30:46|0|1|1|0
>
What does this say:
select *, typeof(interval) from repetition where interval>0 and id=617;
And what does this say:
pragma integrity_check;
>
> It shows a result with "interval" zero, although I requested everything
> above zero.
>
> When I select using the same statement and interval equal to zero, there
> is no result lines.
>
> select * from repetition where interval=0 and id=617
>
> The table looks like:
>
> 0|id|integer|0||1
> 1|last|datetime|1|datetime('now')|0
> 2|interval|integer|0||0
> 3|next|datetime|1|datetime('now')|0
> 4|priority|integer|1|0|0
> 5|repeat|integer|1|1|0
> 6|valid|integer|1|0|0
> 7|sound|integer|1|0|0
>
> Best regards,
> Patrik
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
--
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
