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 <k.n...@zonnet.nl> wrote: On Fri, 13 Jan 2017 08:12:33 + (UTC), "tbuck...@frontier.com" <tbuck...@frontier.com> wrote: > Hello,I have a batch (.bat) file that runs a C progra

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

2017-01-13 Thread tbuck...@frontier.com
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

[sqlite] Using CSV.c

2017-01-10 Thread tbuck...@frontier.com
Hello,I am having a little trouble implementing the csv.c program for SQLite.  Are their any programming examples available? All I want to do is import a csv file to a database, sort the file and output the results to another csv file all in c code.  I can manually do it with the dot (.) tools,