On Thu, 15 Jul 2010 19:14:20 +0000 (UTC), c...@comcast.net wrote: > > >Thanks Kees for your response. > >I tried embedding the ".read" command into my sql script files and it appears >to work fine. > > > >One thing I don't like is having to specify the >full path (relative to where I'm invoking SQLite3 from) >to each file I reference in the scripts I invoke with ".read". > >Is there a way to set a temp variable in a script file that I can use to >specify a file path? >Then I could use that temp var in the file path.
No. But you can make your script directory the current directory, first: cd /path/to/scriptdir sqlite3 /path/to/database/dbfile <script-A >/path/to/outfile scriptA: : .read script-B etcetera -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users