Slightly modified it works:
=== batchfile
REM the read-statement with quotes
sqlite3 test.db ".read r1.sql"
=== r1.sql
REM the following line without quotes
.output o1.txt
select * from table1;
Thanks a lot.
Leo
Simon Davies schrieb:
> 2009/5/7 Leo Freitag :
>
>> Hallo,
>>
>> I try to get ru
Yes, that's what I wanted to do. But even with that syntax there is no
output.
Any other ideas?
Leo
Pavel Ivanov schrieb:
> Maybe you want to do
> sqlite3 test.db ".output o.txt; .read r.sql"
>
> Pavel
>
> On Thu, May 7, 2009 at 6:44 AM, Leo Freitag wrote:
>
>> Hallo,
>>
>> I try to get run
2009/5/7 Leo Freitag :
> Hallo,
>
> I try to get run the following in a batch file
>
> Open database "test.db"
> Set output to "o.txt"
> Read sql-statement form "r.sql"
>
> === r.sql - Start ===
> select * from table1;
> === r.sql - End ===
>
> Thinks like the following didn't work:
> sqlite3 test.
Maybe you want to do
sqlite3 test.db ".output o.txt; .read r.sql"
Pavel
On Thu, May 7, 2009 at 6:44 AM, Leo Freitag wrote:
> Hallo,
>
> I try to get run the following in a batch file
>
> Open database "test.db"
> Set output to "o.txt"
> Read sql-statement form "r.sql"
>
> === r.sql - Start ===
>
Hallo,
I try to get run the following in a batch file
Open database "test.db"
Set output to "o.txt"
Read sql-statement form "r.sql"
=== r.sql - Start ===
select * from table1;
=== r.sql - End ===
Thinks like the following didn't work:
sqlite3 test.db .output o.txt .read r.sql
Thanks for your
5 matches
Mail list logo
