Thank you Kees - this works! I have been running sqlite3.exe simply by clicking on its icon in My Computer and I wrongly assumed that doing this would automatically make the current directory the one where sqlite3.exe is found. When I come to use it from within my Delphi program I shall ensure that I "cd" to the appropriate directory first.
Just a suggestion for the programmers, but it would be helpful if sqlite3.exe came back with a response like "Database <name> opened" or "Database <name> created in directory <name>" - it would give those of us who don't often use command line programs a bit of a clue what's going on. I have forgotten a lot since my DOS days! Thanks once again - I can get on with my work now! Michael Hooker -----Original Message----- From: Kees Nuyt [mailto:[EMAIL PROTECTED] Sent: 30 December 2006 12:38 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Using sqlite.exe On Fri, 29 Dec 2006 18:46:58 -0600, Michael Hooker wrote: >ya, I've found getting to stuff from within the shell program tricky >at times. Here is the easiest way, esp. since your db is in the same >directory as the .exe (assuming that directory to be C:\sqlite3... >replace as needed) > >C:\sqlite3\sqlite3.exe BaseStation.sqb >.. >that will launch sqlite3 as well as open up your database all in one >command. Make that C:\sqlite3\sqlite3.exe C:\sqlite3\BaseStation.sqb or you will end up creating the database in what happens to be the current directory, and then execute .tables or .schema to check what's in there. -- ( Kees Nuyt ) c[_] ---------------------------------------------------------------------------- - To unsubscribe, send email to [EMAIL PROTECTED] ---------------------------------------------------------------------------- - -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.409 / Virus Database: 268.16.0/609 - Release Date: 29/12/2006 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.409 / Virus Database: 268.16.0/609 - Release Date: 29/12/2006 ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------