Re: [sqlite] Exiting SQLite3 from within a (.bat) file

2017-01-13 Thread tbuck...@frontier.com
Thank you.That works great.Tom...
 

On Friday, January 13, 2017 9:46 AM, Kees Nuyt  wrote:
 

 On Fri, 13 Jan 2017 08:12:33 + (UTC),
"tbuck...@frontier.com"  wrote:

> Hello,I have a batch (.bat) file that runs a C program to
> pre-process a text file to a clean .csv file. 
> Then the batch file runs SQLite3 -init to execute dot (.)
> commands.  Everything works great except the last dot
> command ".exit" or ".quit" to close the SQLite3 program
> out.  I always have to manually enter .exit to get back
> to the command prompt.  What can I do to have SQLite3
> automatically exit?

> The batch file has the following commands:
>  cls
>  SOE_sort.exe %1
>  sqlite3.exe -init SOE_sortRC.sqliterc

Try:
  cls
  SOE_sort.exe %1
  sqlite3.exe https://www.sqlite.org/src/artifact?name=6095531aa900decd&ln=5634-5650

A script as redirected input _does_ execute .quit, it even exits
without .quit when the stream reaches end of file.

-- 
Regards,

Kees Nuyt

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


   
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Exiting SQLite3 from within a (.bat) file

2017-01-13 Thread Kees Nuyt
On Fri, 13 Jan 2017 08:12:33 + (UTC),
"tbuck...@frontier.com"  wrote:

> Hello,I have a batch (.bat) file that runs a C program to
> pre-process a text file to a clean .csv file. 
> Then the batch file runs SQLite3 -init to execute dot (.)
> commands.  Everything works great except the last dot
> command ".exit" or ".quit" to close the SQLite3 program
> out.  I always have to manually enter .exit to get back
> to the command prompt.  What can I do to have SQLite3
> automatically exit?

> The batch file has the following commands:
>   cls
>   SOE_sort.exe %1
>   sqlite3.exe -init SOE_sortRC.sqliterc

Try:
   cls
   SOE_sort.exe %1
   sqlite3.exe https://www.sqlite.org/src/artifact?name=6095531aa900decd&ln=5634-5650

A script as redirected input _does_ execute .quit, it even exits
without .quit when the stream reaches end of file.

-- 
Regards,

Kees Nuyt

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users