On Sat, Jun 6, 2009 at 9:30 PM, John Machin<sjmac...@lexicon.net> wrote: > Expected behaviour for various raw file contents: > > 1234 => one row, ok (with luck) > 1234\n => one row, ok > 1234\n\n => first row ok, 2nd is empty, expect error message > 1234\n5678 => two rows, ok (with luck) > 1234\n5678\n => two rows, ok
very correct interpretation, and much better than mine. Essentially, \n\n causes .import to croak if the column being imported into is INTEGER PRIMARY KEY. Makes sense, and yes, a better error message would always be nice. -- Puneet Kishor _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
