[sqlite] Runfile script over existing Database

2011-11-29 Thread Steffen Mangold
Hi all, i have a question. I have a script with edit a database file (insert and alter some tables). Now I want to run this script agains an existing database file, with the commandline shell. How can I do this in a batch file (windows) I don't understand the .read command. Regards Steffen

Re: [sqlite] Runfile script over existing Database

2011-11-29 Thread Black, Michael (IS)
: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Steffen Mangold [steffen.mang...@balticsd.de] Sent: Tuesday, November 29, 2011 12:46 PM To: sqlite-users@sqlite.org Subject: EXT :[sqlite] Runfile script over existing Database Hi all, i have a question. I have

Re: [sqlite] Runfile script over existing Database

2011-11-29 Thread Steffen Mangold
] Sent: Tuesday, November 29, 2011 12:46 PM To: sqlite-users@sqlite.org Subject: EXT :[sqlite] Runfile script over existing Database Hi all, i have a question. I have a script with edit a database file (insert and alter some tables). Now I want to run this script agains an existing database file

Re: [sqlite] Runfile script over existing Database

2011-11-29 Thread Black, Michael (IS)
From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Steffen Mangold [steffen.mang...@balticsd.de] Sent: Tuesday, November 29, 2011 1:41 PM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] Runfile script over existing Database Thanks

Re: [sqlite] Runfile script over existing Database

2011-11-29 Thread Pavel Ivanov
On Tue, Nov 29, 2011 at 2:56 PM, Black, Michael (IS) michael.bla...@ngc.com wrote: In your words: 1. start cmd.exe 2. go to directory with sqlite3.exe 3. type test.sql | sqlite3 test.db3 (Return) Don't get confused: you should type the word type here. ;) Pavel

Re: [sqlite] Runfile script over existing Database

2011-11-29 Thread Steffen Mangold
Thank you that works :) ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Runfile script over existing Database

2011-11-29 Thread Steffen Mangold
From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Steffen Mangold [steffen.mang...@balticsd.de] Sent: Tuesday, November 29, 2011 1:41 PM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] Runfile script over existing Database Thanks for your

Re: [sqlite] Runfile script over existing Database

2011-11-29 Thread Roger Andersson
On 11/29/11 23:25, Steffen Mangold wrote: Now i have the problem that the sqlite3.exe has a problem with ä, ö, ü in Database filename. :( It makes a new db called D�sseldorf for example and fails then :( Steffen Mangold Try creating a bat-file with the cmd-commands and run it. /Roger