> Table will then be like this: > > FIELD1 FIELD2 > --------------------------------- > 0 FIELD2 > 1 ABC > 2 BCD > 3 CDE
How did you arrive at this -- the table looks NOTHING like what you (I can only assume) you ASSUMED it looks like. Instead of assuming what the table looks like, why not actually SEE what it looks like by executing: Select * from QQQ; The error of your untested assumption should then be clear ... --- () ascii ribbon campaign against html e-mail /\ www.asciiribbon.org > -----Original Message----- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Bart Smissaert > Sent: Saturday, 08 June, 2013 08:43 > To: General Discussion of SQLite Database > Subject: [sqlite] Strange table behaviour after text import with > sqlite3.exe > > 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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
