Latest SQLite, 2000 to XP. I have the output to text working now when I type it at the command prompt, but I now need to figure out how to do the whole sequence without any user action. I has to run from VB or maybe a VBS file or anything that can be initiated from VB/VBA.
RBS -----Original 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 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 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 here. > > RBS > > > > ---------------------------------------------------------------------------- - > To unsubscribe, send email to [EMAIL PROTECTED] > ---------------------------------------------------------------------------- - > > ____________________________________________________________________________ ________ Sponsored Link $200,000 mortgage for $660/ mo - 30/15 yr fixed, reduce debt - http://yahoo.ratemarketplace.com ---------------------------------------------------------------------------- - To unsubscribe, send email to [EMAIL PROTECTED] ---------------------------------------------------------------------------- - ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
