You're seeing on of my pet peeves...error messages like "cannot open file" or
Microsoft's famous "cannot load dll". Some of us need to know WHY.
So, change all your "cannot open" lines in shell.c to this:
fprintf(stderr, "Error: cannot open \"%s\":%s\n", zFile, strerror(errno));
Then you'll see the real errror which could be permissions, not found, or some
other.
And if it says "No such file..." then maybe you have some funky character. Can
you "more" the filename?
Then show us your complete line of execution like this:
vi test.txt (insert line '1')
./sqlite3 test.db
create table test2(code integer);
.import 'test.txt' test2
And the resultant error message.
Michael D. Black
Senior Scientist
Advanced Analytics Directorate
Advanced GEOINT Solutions Operating Unit
Northrop Grumman Information Systems
________________________________
From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on
behalf of Helen Chen [xche...@partners.org]
Sent: Monday, December 05, 2011 12:41 PM
To: sqlite-users@sqlite.org
Subject: EXT :[sqlite] import data error message cannot open file
Dear all,
I am using Mac OX to run sqlite 3. In sqlite 3 I typed in
create table test2(code integer); Then I typed
.import 'cheps.txt' test 2 It then give me error message saying that cannot
open "cheps.txt" I also tried without the '' around the file name. The
database, the text file and sqlite.ext are in the same path. Can any one tell
me why this is the case? Thank you very much.
Helen
The information in this e-mail is intended only for the person to whom it is
addressed. If you believe this e-mail was sent to you in error and the e-mail
contains patient information, please contact the Partners Compliance HelpLine at
http://www.partners.org/complianceline . If the e-mail was sent to you in error
but does not contain patient information, please contact the sender and properly
dispose of the e-mail.
_______________________________________________
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
