On Wed, Mar 14, 2012 at 10:04 PM, YAN HONG YE <[email protected]> wrote:
> On Tue, 13 Mar 2012 02:28:38 +0000, YAN HONG YE <[email protected]> > wrote: > > >here my code,where is wrong? > >char mma[250]; > >strcpy(mma,"sqlite3 foods.db \" .separator ',' \" \".import > dzhhkmysql.txt dzh\""); > >system(mma); > > dot-commands for the sqlite3 command line tool have to be on separate > lines. > > Do the equivalent of: > printf ".separator ','\n.import dzhhkmysql.txt dzh\n" | sqlite3 foods.db > > C:\sqlite\lib>".separator ',' \n .import ddl.txt dzh \n" | sqlite3 foods.db > The system cannot find the path specified. > but the two file ddl.txt and foods.db certainty under C:\sqlite\lib\ > _______________________________________________ > 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 -- -- -- --ô¿ô-- K e V i N _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
