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 > -- Puneet Kishor http://punkish.eidesis.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
