Patrik Nilsson wrote:
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
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
What do you get with query
select * from repetition where cast(interval as integer)==0 and
interval>0
?
--
Larry Brasfield
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users