[sqlite] .separator \t not working

[none given]

Hi,

I am having issues running an import from the command line (on a Mac).

When running:
sqlite3 separator '\t' test.db ".import data.csv wc2" 

I get the error : 

line 1: expected 27 columns of data but found 1

(the file and the table structure both exist).

I then attempt the 3 variations of the statement as such :
sqlite3 test.db ".separator '\t' .import data.csv wc2" 
sqlite3 test.db ".separator \t .import data.csv wc2" 
sqlite3 test.db ".separator '\t' \n .import data.csv wc2" 

To no avail...

But, if I create a .sqliterc file containing : .separator \t then the import 
works.

Why is it I can successfully import with an sqliterc file, but it fails via the 
command line? 

As I am running the command from an Xcode NTask, I could really do without the 
sqliterc file...

What am I doing wrong?

Tia,

S.


      
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users