Hi,
the .import command does not work (and can show misleading error messages)
if the table name contains special characters:
sqlite> .import test.csv temp.t
Error: no such table: temp.t
sqlite> select * from temp.t;
sqlite>
This appears to be caused by inconsistent quoting of the table name:
zSql = sqlite3_mprintf("SELECT * FROM %s", zTable);
char *zCreate = sqlite3_mprintf("CREATE TABLE %s", zTable);
sqlite3_snprintf(nByte+20, zSql, "INSERT INTO \"%w\" VALUES(?", zTable);
Regards,
Clemens
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
