On Fri, 13 Jun 2008 15:27:19 +1000, John wrote: >Hi > >I am trying to put multiple commands/statements in a command line args >list to sqlite3 (Win XP command line/batch file). > >This works (sq is alias for sqlite3.exe): >sq data\data1.db3 "DROP TABLE IF EXISTS list; VACUUM; CREATE TABLE IF >NOT EXISTS list (Assno,Custno);" > >These are all statements. > >This does not work: >sq data\data1.db3 ".mode column" "select >assno,custno,asset,custnum,branch from list,a1 where asset == assno;" > >A "." command followed by a statement. > >Variations I have tried: >- quoting the full arg list as a single string >- using ; / \ \n \r \r\n as separators after column > >Can this be made to work? and if so, how?
Use the gnu version of echo, available on http://unxutils.sourceforge.net/ , enclose all command between one pair of double quotes and use \n as a newline between commands. Or use the solution of Simon Davies. -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
