On Fri, 16 Mar 2012 02:16:03 +0000, YAN HONG YE <yanhong...@mpsa.com>
wrote:
>On Date: Wed, 14 Mar 2012 23:13:57 -0400
>From: Kevin Benson <kevin.m.ben...@gmail.com>
>wrote:
>
>Quick solution to above error may be to try path with forward slashes:
>
>C:\sqlite\lib>".separator ',' \n .import /sqlite/lib/ddl.txt dzh \n" |
>sqlite3 /sqlite/lib/foods.db
>
>and 8.3 path format where needed:
>
>C:\sqlite\lib>".separator ',' \n .import /progra~1/sqlite/lib/ddl.txt dzh
>\n" | /progra~1/sqlite/lib/foods.db
>
>When I use this code, It can't work. and the same error msg.
In the MS Windows CMD shell, the way to bundle outputs of multiple
commands into one stream is by enclosing them in parenthesis.
Try this in a .cmd file :
-------------------------
@echo off
(
echo .separator ','
echo .bail ON
echo .import /sqlite/lib/ddl.txt dzh
) | sqlite3 foods.db
-------------------------
--
Regards,
Kees Nuyt
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
