Whatever it gets turned into, my question is how I can select that record
with a where
clause specifying field1?
Surely, there must be some way.
RBS
On Sat, Jun 8, 2013 at 3:48 PM, Michael Black <mdblac...@yahoo.com> wrote:
> What makes you think field1 gets turned into a zero? Fields are really
> typeless in SQLite3
>
> Your .dump should look like this:
>
> SQLite version 3.7.16.2 2013-04-12 11:52:43
> Enter ".help" for instructions
> Enter SQL statements terminated with a ";"
> sqlite> CREATE TABLE QQQ([FIELD1] INTEGER, [FIELD2] TEXT);
> sqlite> .mode csv
> sqlite> .import qqq qqq
> Error: cannot open "qqq"
> sqlite> .import qqq.txt qqq
> sqlite> .dump
> PRAGMA foreign_keys=OFF;
> BEGIN TRANSACTION;
> CREATE TABLE QQQ([FIELD1] INTEGER, [FIELD2] TEXT);
> INSERT INTO "QQQ" VALUES('FIELD1','FIELD2');
> INSERT INTO "QQQ" VALUES(1,'ABC');
> INSERT INTO "QQQ" VALUES(2,'BCD');
> INSERT INTO "QQQ" VALUES(3,'CDE');
> COMMIT;
>
>
>
> -----Original Message-----
> From: sqlite-users-boun...@sqlite.org
> [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Bart Smissaert
> Sent: Saturday, June 08, 2013 9:43 AM
> 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
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
