Where do you execute the SQLite program from? Is it just the sqlite.exe file?
P Kishor-2 wrote: > > I like using .sqlite as the extension (or .sqlite3). That way no > Windows program will want to mess with it... usually 3 letter > extensions are grist for the mill > > On 11/27/06, John Stanton <[EMAIL PROTECTED]> wrote: >> Use anything you like. Version 3 Sqlite is easy to recognize if you use >> .db3. >> >> RB Smissaert wrote: >> >>sqlite3 mydatabase.db3 >> > >> > >> > I always use the extension .db >> > What is the difference between db3 and db or maybe db2 etc.? >> > >> > RBS >> > >> > >> > -----Original Message----- >> > From: Kees Nuyt [mailto:[EMAIL PROTECTED] >> > Sent: 27 November 2006 22:49 >> > To: sqlite-users@sqlite.org >> > Subject: Re: [sqlite] Saving tables >> > >> > On Mon, 27 Nov 2006 12:43:24 -0800 (PST), you wrote: >> > >> > >> >>I typed exactly what you typed there and i get >> >>SQL error: no such table: bar >> >>my command window doesnt have : "sqlite3 foo.sqlite" like yours >> > >> > >> > If you don't include a database name after the sqlite3 command, >> > sqlite uses the "memory" database, which ceases to exist after >> > you exit the program. >> > >> > So, use the following commamnd to create and open your database: >> > sqlite3 mydatabase.db3 >> > >> > and then issue the SQL commands at the prompt to create and >> > populate the table. >> > >> > Every time you want to reuse that database, you have to open it >> > in the same way: >> > sqlite3 mydatabase.db3 >> > >> > HTH >> >> >> ----------------------------------------------------------------------------- >> To unsubscribe, send email to [EMAIL PROTECTED] >> ----------------------------------------------------------------------------- >> >> > > > -- > Puneet Kishor http://punkish.eidesis.org/ > Nelson Inst. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/ > Open Source Geospatial Foundation https://edu.osgeo.org/ > ------------------------------------------------------------------------------------------------------- > collaborate, communicate, compete > ==================================================== > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > > > -- View this message in context: http://www.nabble.com/Saving-tables-tf2714011.html#a7577190 Sent from the SQLite mailing list archive at Nabble.com. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------