Re: [sqlite] Beginner Problem...
On Thu, 17 Feb 2005 16:34:07 +0100, Peter Berkenbosch <[EMAIL PROTECTED]> wrote: > Yes :) > > -Oorspronkelijk bericht- > Van: Claudio Bezerra Leopoldino [mailto:[EMAIL PROTECTED] > Verzonden: donderdag 17 februari 2005 16:25 > Aan: SQLiter Mailing List > Onderwerp: [sqlite] Beginner Problem... > > > I've used SQLite utility to learn about the library, > but have a doubt... > I need to submit sql text scripts to the utility > instead of command line sql code. It´s possible? > > Cláudio Leopoldino > > ___ > Yahoo! Acesso Grátis - Instale o discador do Yahoo! agora. > http://br.acesso.yahoo.com/ - Internet rápida e grátis > > -- > No virus found in this incoming message. > Checked by AVG Anti-Virus. > Version: 7.0.300 / Virus Database: 265.8.8 - Release Date: 14-2-2005 > > -- > No virus found in this outgoing message. > Checked by AVG Anti-Virus. > Version: 7.0.300 / Virus Database: 265.8.8 - Release Date: 14-2-2005 > > somewhat more helpfully :), .read replace with the name of your script. I have had some trouble with this, when reading in files which have binary-encoded data (using sqlite_binary_encode), but for everything else, it works fine. I would also use .output when reading scripts; if there are any errors, the information scrolls by a little two quickly, and if the script is long, the scroll buffer will lose the info: .output myoutputfile.txt To redirect to stdout, use: .output stdout For help: .help --Keith -- ** - Ever notice how 'big' isn't, compared to 'small'? - Sounds like a Wookie; acts like mad cow. - I'm not a professional; I just get paid to do this. - Rules for programming: 1. Get it working, right? 2. Get it working right. - Things I've learned about multithreaded programming: 123... PPArrvooottieedcc ttm ueelvvteeirrtyyhtt rhheiianndgge dwi hnpi rctohhg eri aslm omscitanalgt iowcbh,je engceltvo ebwrah lip,co hso srci abonlt ehb .ee^Nr waicscee snsoetd 'aotb jtehcet -slaomcea lt'il m^Ne from two or more threads **
RE: [sqlite] Beginner Problem...
EG: % sqlite3 test.db < /data/temp/test.sql -Oorspronkelijk bericht- Van: Claudio Bezerra Leopoldino [mailto:[EMAIL PROTECTED] Verzonden: donderdag 17 februari 2005 16:25 Aan: SQLiter Mailing List Onderwerp: [sqlite] Beginner Problem... I've used SQLite utility to learn about the library, but have a doubt... I need to submit sql text scripts to the utility instead of command line sql code. It´s possible? Cláudio Leopoldino ___ Yahoo! Acesso Grátis - Instale o discador do Yahoo! agora. http://br.acesso.yahoo.com/ - Internet rápida e grátis -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.8 - Release Date: 14-2-2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.8 - Release Date: 14-2-2005
RE: [sqlite] Beginner Problem...
Yes :) -Oorspronkelijk bericht- Van: Claudio Bezerra Leopoldino [mailto:[EMAIL PROTECTED] Verzonden: donderdag 17 februari 2005 16:25 Aan: SQLiter Mailing List Onderwerp: [sqlite] Beginner Problem... I've used SQLite utility to learn about the library, but have a doubt... I need to submit sql text scripts to the utility instead of command line sql code. It´s possible? Cláudio Leopoldino ___ Yahoo! Acesso Grátis - Instale o discador do Yahoo! agora. http://br.acesso.yahoo.com/ - Internet rápida e grátis -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.8 - Release Date: 14-2-2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.8 - Release Date: 14-2-2005
[sqlite] Beginner Problem...
I've used SQLite utility to learn about the library, but have a doubt... I need to submit sql text scripts to the utility instead of command line sql code. It´s possible? Cláudio Leopoldino ___ Yahoo! Acesso Grátis - Instale o discador do Yahoo! agora. http://br.acesso.yahoo.com/ - Internet rápida e grátis