On 7 Sep 2015, at 8:00am, Petr L?z?ovsk? <lazna at volny.cz> wrote:
> Uhgh.... Spent lot of time to made whole scripts bundle to use no tempfiles
> (avoiding I/Os), and not this ;-)
> OK, few more questions:
>
> Does sqlite3 expect exactly one statement per one line on input?
> Or put it into command line? sqlite3.exe %db% "%multiline_statement%" (have
> seriuos doubts about this solution)
> Or this? echo "%multiline_statement%"|sqlite3.exe %db%
I can tell you if this works on the Macintosh version but this may not
necessarily mean it works on the version for your operating system.
If not, create a text file with the commands in then feed it the text file.
The command could look like
sqlite3 %db% < theCommands.txt
I think the structure you used above ...
Unix/Linux:
cat theCommands.txt | sqlite3.exe %db%
Windows:
type theCommands.txt | sqlite3.exe %db%
will also work.
You may find it useful to figure out a way of generating a filename which will
never be repeated. When I try to do this I usually end up with something which
relates to the current time.
Simon.
