Have table defined like this: CREATE TABLE QQQ([FIELD1] INTEGER, [FIELD2] TEXT)
Table is empty, so has no records. Then I import a text file with this data: FIELD1,FIELD2 1,ABC 2,BCD 3,CDE This is via sqlite3.exe with: .mode csv .import textfilename QQQ Table will then be like this: FIELD1 FIELD2 --------------------------------- 0 FIELD2 1 ABC 2 BCD 3 CDE This is all fine and as expected. However I am unable to produce any records when doing a select with a where clause specifying field1 to be zero. Tried all: select * from qqq where field1 = 0 select * from qqq where field1 = '0' select * from qqq where field1 = '' select * from qqq where field1 is null Nil producing a record. Any idea what is going on here or what I might be doing wrong? RBS _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
