On Thu, 15 Jul 2010 17:54:38 +0000 (UTC), [email protected]
wrote:

>
>
>
>I have a file which contains SQLite and SQLite/SQL commands. 
>
>I can invoke that file and successfully execute all
>of the commands in that file by starting a SQLite cmd
>line session and using the ".read" command. 
>
>I'll refer to that as script-C. 
>
>
>What I would like to do is create a higher level command file (script-A)
>which not only contains SQLite and SQLite/SQL commands , but will also
>invoke script-C; and script-B, and other yet-to-be created scripts
>(in the future). 
>
>My question is, what command do I use in script-A to
>invoke script-C, script-B, etc? 

Invoke script-A this way:

sqlite3 yourdbfile <script-A >outputfile

and in script-A, use 

:
.read script-C
:
.read script-B
:

You can even change the output file on the fly with:
.output FILENAME

and back to the redirection with:
.output stdout

-- 
  (  Kees Nuyt
  )
c[_]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to