Where do you execute the SQLite program from? Is it just the sqlite.exe file?
John Stanton 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] > ----------------------------------------------------------------------------- > > > -- View this message in context: http://www.nabble.com/Saving-tables-tf2714011.html#a7577236 Sent from the SQLite mailing list archive at Nabble.com. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------