Re: [sqlite] SQL command support question

2007-10-02 Thread John Stanton
Those commands are specific to the sqlite3 command line tool program. Run sqlite3 from a command line to get them. José Antonio Gonçalves Motta wrote: I'm accessing SQLite through a JDBC driver in a java program, but I get an error everytime I use SQLite line command (like ".output"). Is it

RE: [sqlite] SQL command support question

2007-10-02 Thread Griggs, Donald
Regarding: I'm accessing SQLite through a JDBC driver in a java program, but I get an error everytime I use SQLite line command (like ".output"). Is it because the driver doesn't understand those commands?" Commands such as ".output" are not part of sqlite proper. They are part of the

RE: [sqlite] SQL command support question

2007-10-01 Thread Griggs, Donald
Regarding: "I was wondering if SQLite supports the command SELECT ... INTO OUTFILE ..." No, but the sqlite3 command-line utility supports an equivalent: .output outfile.csv .select . .output stdout You may also want to look at the commands .separator .mode .header

Re: [sqlite] SQL command support question

2007-10-01 Thread Dwight Ingersoll
> > I was wondering if SQLite supports the command > SELECT ... INTO OUTFILE ... Can't you accomplish this in the programming language you're using to access the SQLite database? The SQLite command line utility ( http://www.sqlite.org/sqlite.html) has an option for specifying an output file.