Slightly modified it works: === batchfile REM the read-statement with quotes sqlite3 test.db ".read r1.sql"
=== r1.sql REM the following line without quotes .output o1.txt select * from table1; Thanks a lot. Leo Simon Davies schrieb: > 2009/5/7 Leo Freitag <leofrei...@netcologne.de>: > >> Hallo, >> >> I try to get run the following in a batch file >> >> Open database "test.db" >> Set output to "o.txt" >> Read sql-statement form "r.sql" >> >> === r.sql - Start === >> select * from table1; >> === r.sql - End === >> >> Thinks like the following didn't work: >> sqlite3 test.db .output o.txt .read r.sql >> > > Only 1 dot command can be supplied in the first command string. > > Make the first line of r.sql ".output o.txt" > > Then: > sqlite3 test.db ".read r.sql" > > >> Thanks for your help. >> Leo >> >> > > Rgds, > Simon > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
