elect from commandprompt with output to file
RB Smissaert wrote:
How would I run these 4 commands via a .bat file or via whatever means:
cd c:\test\ReadCodes
c:\test\Program\sqlite3 c:\test\ReadCodes\ReadCode.db"
.output testfile.txt
select * from readcode where read_code glob 'G2*';
t have the option to output to memory, say
an array and produce the pointer to that memory, rather than a text file?
RBS
-Original Message-
From: Dennis Cote [mailto:[EMAIL PROTECTED]
Sent: 17 November 2006 15:04
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] select from commandprompt w
Dennis,
Thanks for that. Will try it later and let you know.
Definitely one I couldn't have figured out myself.
RBS
-Original Message-
From: Dennis Cote [mailto:[EMAIL PROTECTED]
Sent: 17 November 2006 15:04
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] select from commandp
RB Smissaert wrote:
How would I run these 4 commands via a .bat file or via whatever means:
cd c:\test\ReadCodes
c:\test\Program\sqlite3 c:\test\ReadCodes\ReadCode.db"
.output testfile.txt
select * from readcode where read_code glob 'G2*';
It must be simple, but I can't see it.
RBS,
You n
Message-
From: Dan Kennedy [mailto:[EMAIL PROTECTED]
Sent: 17 November 2006 08:09
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] select from commandprompt with output to file
What sqlite versions, OS etc.? This worked for me:
$ sqlite3
SQLite version 3.2.8
Enter ".help" for in
01:15
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] select from commandprompt with output to file
"RB Smissaert" <[EMAIL PROTECTED]> writes:
> How would I run these 4 commands via a .bat file or via whatever means:
>
> cd c:\test\ReadCodes
> c:\test\Program\sqli
What sqlite versions, OS etc.? This worked for me:
$ sqlite3
SQLite version 3.2.8
Enter ".help" for instructions
sqlite> create table abc(a, b, c);
sqlite> .output out.txt
sqlite> select * from sqlite_master;
sqlite> .quit
$ cat out.txt
table|abc|abc|2|CREATE TABLE abc(a, b, c)
>
> How do I d
"RB Smissaert" <[EMAIL PROTECTED]> writes:
> How would I run these 4 commands via a .bat file or via whatever means:
>
> cd c:\test\ReadCodes
> c:\test\Program\sqlite3 c:\test\ReadCodes\ReadCode.db"
> .output testfile.txt
> select * from readcode where read_code glob 'G2*';
I haven't been trackin
Original Message-
From: Kees Nuyt [mailto:[EMAIL PROTECTED]
Sent: 16 November 2006 21:36
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] select from commandprompt with output to file
Hi RBS,
On Thu, 16 Nov 2006 19:56:36 -, you wrote:
>How do I do this:
>From the command pr
Subject: Re: [sqlite] select from commandprompt with output to file
Hi RBS,
On Thu, 16 Nov 2006 19:56:36 -, you wrote:
>How do I do this:
>From the command prompt issue a simple select query to a specified database
>and direct the output to a file.
>I can see there is the .out
Hi RBS,
On Thu, 16 Nov 2006 19:56:36 -, you wrote:
>How do I do this:
>From the command prompt issue a simple select query to a specified database
>and direct the output to a file.
>I can see there is the .output FILENAME option, but nothing seems to happen.
>.output stdout works fine with o
How do I do this:
>From the command prompt issue a simple select query to a specified database
and direct the output to a file.
I can see there is the .output FILENAME option, but nothing seems to happen.
.output stdout works fine with output to the screen.
Must be overlooking something simple her
12 matches
Mail list logo
