Re: [sqlite] One line batch file?

2007-11-13 Thread John
Owen Watson wrote: I'd like to have a one line batch file: sqlite3 test 'insert into testable values ('value1','value2')' have you tried something like: echo insert into testable values ('value1', 'value2'); | sqlite3 test note ";" at end of statement and "|" pipe char in command line. This s

Re: [sqlite] One line batch file?

2007-11-12 Thread Dennis Cote
Owen Watson wrote: I'd like to have a one line batch file: sqlite3 test 'insert into testable values ('value1','value2')' but the few variants of this I've tried don't work. I've seen and understood the batch file that calls another text file approach but I was wondering if I could avoid this

[sqlite] One line batch file?

2007-11-11 Thread Owen Watson
I'd like to have a one line batch file: sqlite3 test 'insert into testable values ('value1','value2')' but the few variants of this I've tried don't work. I've seen and understood the batch file that calls another text file approach but I was wondering if I could avoid this overhead for a one-li