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 <name of file>
replace <name of file> 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
******************************************************
