I did. I just download the precompiled binaries for Windows, and this is
what I see (for that sample data file):
C:\temp>sqlite3.exe
SQLite version 3.8.0 2013-08-26 04:50:08
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .sep ,
sqlite> .import data tab
data:2: unterminated "-quoted field
sqlite>
-----Original Message-----
From: Richard Hipp
Sent: Wednesday, August 28, 2013 3:47 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] v3.8 .import misbehaves
On Wed, Aug 28, 2013 at 8:25 AM, <to...@acm.org> wrote:
For example, here's a sample (header + one line of data) that fails -- a
lot more lines fail but I cut it down just to show the problem:
"Year","Debt","GDP1","GDP2","**RGDP","dRGDP","Infl","debtgdp"
"1833","","49.3275923134","","**118.3483703666","","",""
Then, doing
.sep ,
.import data tab
gives error(s).
Unable to reproduce the problem. The example above works correctly for me
using SQLite 3.8.0 on Linux and on Windows8.
Please verify that you are using 3.8.0 (where this problem has been fixed)
and not SQLite version 3.7.17 or earlier.
--
D. Richard Hipp
d...@sqlite.org
_______________________________________________
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
