On 16 Jul 2009, at 10:24am, Uijtdewilligen, Freek wrote: > I have used SMALLINT, but the same problem occurred when I > changed it to INTEGER.
INTEGER should be correct. Can we see the command you use to make the TABLE t_rp, please ? > When I'm storing a location (x,y,z) into the database that contains > a 0, > like: > > INSERT INTO t_rp (x, y, z) > VALUES (1, 1, 0); > > it gets stored as (1,1,null). Something is wrong at that stage, as you write. If you type the same command into the sqlite3 command-line tool, do you get the same results ? If you are getting any results different to what <http://www.sqlite.org/datatype3.html> predicts, something is wrong. > Then, if I try to query something like > > SELECT z FROM t_rp WHERE z=='0'; > > No rows are returned. Try SELECT z FROM t_rp WHERE z==0; instead. Putting quotes around the value makes it a string. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users