Brad,
I found the problem and if I'd learn how to read :-) I wouldn't have sent the email. Now I know that nothing coming back means that all is OK and anything coming back means an error.
Thanks,
Michael
At 10:31 AM 1/3/2005, Brass Tilde wrote:
> My initial question is this: I have a set of SQL statements in a file that > builds my desired database. In reading the command line options for sqlite3 > it appeared the ".read" command would read this file and execute the > statements in the file specified.
> Yet when I do that, I see the statements come flying across my command > window but there's nothing to indicate success or failure
After running the script, can you select from the tables created? There should be nothing in them, of course, but you should be able to execute a "select * from <table>;" without generating an error.
IME, the SQLITE3.EXE program reports errors when it can't create the tables, or encounters problems, so no message should mean success.
> and the database file I specified stays at zero length. So obviously > that doesn't work.
Not so obvious to me. Are you looking at the file size while the SQLITE?.exe program still has the file open, or *after* exiting the SQLITE command line back to your shell?
> Can anyone please tell me if there is any way to perform the batch > processing of the SQL statements in my file?
Unless I'm misunderstanding what you've done, what you've done works for me. It's how I check the validity of my creation, and other, scripts.
Brad
