It should work fine with filenames with semicolons. My problem is when I include the trailing semicolon, and it isn't really part of the filename or table name.
You _might_ need to use forward slashes instead of backslashes as the path separator inside the SQLite shell on Windows. Or you might need to use double backslashes. I remember having an issue like this, but I don't remember the details. I've just started putting the files in the default dir. -Clark ----- Original Message ---- From: John Salerno <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org; [EMAIL PROTECTED] Sent: Wednesday, August 23, 2006 1:22:03 PM Subject: Re: [sqlite] running a script? Thanks guys. Does any of this change for Windows though? I don't believe I can use cat or | in the command prompt. I've also tried some of those structures already and there seems to be a problem with my file paths: C:\name\name\file.ext I don't know if it's the colon or the slashes, but it won't work properly. And about using .read and .import, does this mean you can't use them on files that have semicolons in them? On 8/23/06, Ulrich Schöbel <[EMAIL PROTECTED]> wrote: > On Wednesday 23 August 2006 21:45, John Salerno wrote: > > Hi everyone. Can someone tell me the proper syntax for running a sql > > script when starting up sqlite from the command line interface? > > > > Thanks, > > John > > > > --------------------------------------------------------------------------- > >-- To unsubscribe, send email to [EMAIL PROTECTED] > > --------------------------------------------------------------------------- > >-- > > cat scriptfile | sqlite3 mydb > > or > > sqlite3 -init scriptfile mydb > > or > > sqlite3 mydb < scriptfile > > or (for a single sql command) > > sqlite3 mydb 'sqlcmd' > > Kind regards > > Ulrich > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
