Thanks. That's what I needed. I didn't get your earlier message because I signed up for the digest.
My problem was that I was just clicking on sqlite3.exe instead of running it from the command line. -Ryan P Kishor wrote: > On 9/30/08, Ryan Walker <[EMAIL PROTECTED]> wrote: > >> Hi Enrique, >> I'm not referring to the syntax. I know the syntax. I'm wondering how >> to connect to a local database with sqlite3.exe. That is, how do I tell >> sqlite3.exe where the database file is on my computer? When I use the >> .databases command, my database is not listed, so I assume I need to >> tell sqlite3.exe where it is. >> > > did you not get my earlier response? > > commandline> sqlite3.exe <name of your database file> > > Assuming your database is called foo.sqlite, and is sitting under > c:\bar directory. Assuming your program sqlite3.exe is in your path, > you would do like so > > c:\bar> sqlite3.exe foo.sqlite > > That would "connect" your program to your database. Then you can do > what you want. > > If you don't provide a database name, you get no database. You can > create temporary databases. > > Hope this helps. > > > >> -Ryan >> >> >> >> Enrique Ramirez wrote: >> > You mean a command like ALTER TABLE? Maybe check the SQL Syntax >> > available to SQLite (http://sqlite.org/lang_altertable.html) >> > >> > On Tue, Sep 30, 2008 at 4:09 PM, Ryan Walker <[EMAIL PROTECTED]> wrote: >> > >> >> Hi, >> >> I have a database file in windows that I want to connect to with >> >> sqlite3.exe so I can add a column to a table. Not sure how to so it. >> >> There doesn't appear to be any relevant command when I enter .help. >> >> Thanks, >> >> Ryan >> >> >> >> >> >> -- >> >> Ryan Walker >> >> www.WebCommunicate.net: >> >> Insights and resources for effective websites. >> >> >> >> _______________________________________________ >> >> sqlite-users mailing list >> >> sqlite-users@sqlite.org >> >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> >> >> >> >> > >> > >> > >> > >> >> >> -- >> Ryan Walker >> www.WebCommunicate.net: >> Insights and resources for effective websites. >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> >> > > > -- Ryan Walker www.WebCommunicate.net: Insights and resources for effective websites. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
