Re: [sqlite] how to read schema file into database with tcl

2011-03-08 Thread mweiguo
于 2011-3-8 23:37, Gary_Gabriel 写道: > Hi mweiguo, >> hi all: >> i am writing a tcl script, it will create a empty database and read a >> schema file into database ... >> in command line, it works when i use >> .read schema.sql >> but in tcl script enviroment, how can i do that ?

Re: [sqlite] how to read schema file into database with tcl

2011-03-08 Thread Gary_Gabriel
Hi mweiguo, > hi all: > i am writing a tcl script, it will create a empty database and read a > schema file into database ... > in command line, it works when i use > >>> .read schema.sql >>> > but in tcl script enviroment, how can i do that ? > This script reads the *.sql file as a

Re: [sqlite] how to read schema file into database with tcl

2011-03-08 Thread Simon Slavin
On 8 Mar 2011, at 6:45am, mweiguo wrote: > but in tcl script enviroment, how can i do that ? Read the text file into a string and execute it. If your text file is very very long, read it line by line and execute one line at a time. Simon. ___

[sqlite] how to read schema file into database with tcl

2011-03-07 Thread mweiguo
hi all: i am writing a tcl script, it will create a empty database and read a schema file into database ... in command line, it works when i use >> .read schema.sql but in tcl script enviroment, how can i do that ? thanks ___ sqlite-users mailing list