Regarding:
"...but this doesn't work because the .mode tabs isn't separated from
the regular SQL.
Could someone point out how to accomplish this?"
If I understand correctly, all you need to do is write the desired
commands out to a text file, then either direct stdin to the text file,
or use the '.read" command.
With Windows, FWIW, I have more luck with .read , e.g.
Sqlite3 NLSY.db ".read MyFileOfCommands.sql"
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
