Josef Hlawatschek (JT) wrote:
Hi,
I want to use SQLITE3.EXE to run automated reports in Windows. I use
an init file to load parameters and a SQL script file. All goes well
until the SQL script has been executed, then the SQLITE3.EXE command
prompt appears. The command prompt only closes once you manually type
in ".exit" or ".quit". I have tried to add the ".exit" to the init and
SQL script file and it still does not close automatically.
I do not need to programmatically connect to the SQLITE DB, so I would
like to keep it as simple as possible.
Why not use a pipe:
- Put all commands in a file, say, sqlite.cmds
- Run SQLite3.exe with the following command:
> sqlite3.exe < sqlite.cmds
That should work.
Regards,
Arjen