RE: [sqlite] opening a database in command prompt in Windows

2006-08-21 Thread Brannon King
Dragging a database onto the sqlite.exe in explorer works. > I downloaded the command line utility, and it is an exe file > that automatically opens the sqlite prompt. Given this, how > am I supposed to open or create databases? The only way I'm > aware so far is that you have to specify the d

Re: [sqlite] opening a database in command prompt in Windows

2006-08-21 Thread John Salerno
Yeah, I just moved the exe file elsewhere on my hard drive and put it's destination in my PATH. So now I can type 'sqlite3 ' and open a database. On 8/21/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: "John Salerno" <[EMAIL PROTECTED]> wrote: > I downloaded the command line utility, and it is

Re: [sqlite] opening a database in command prompt in Windows

2006-08-21 Thread drh
"John Salerno" <[EMAIL PROTECTED]> wrote: > I downloaded the command line utility, and it is an exe file that > automatically opens the sqlite prompt. Given this, how am I supposed > to open or create databases? The only way I'm aware so far is that you > have to specify the db after the sqlite3 co

Re: [sqlite] opening a database in command prompt in Windows

2006-08-21 Thread Levi Wilson
You may want to download the SQL Lite Database project from sourceforge. On 8/21/06, John Salerno <[EMAIL PROTECTED]> wrote: I downloaded the command line utility, and it is an exe file that automatically opens the sqlite prompt. Given this, how am I supposed to open or create databases? The on