John wrote:
> I am having problems creating a "do shell script" command which includes
> both the import command and the insert command. The reason they need to be
> combined is that the shells instance ends with the command.
>
> do shell script ("sqlite3 " & databasePath & " .separator \"||\" ; .import
> path/to/csv Main")
Dot commands are not SQL commands; they must be separated by newlines.
If you cannot generate newline characters, try to execute something
like this:
(echo .separator "||"; echo .import path tbl) | sqlite3 dbfile
Regards,
Clemens
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
