Don't know why you are using the "backdoor" approach (Calling the SQLite.exe module) accessing an SQLite database from Delphi, but you might want to look at what these people have to offer:
www.aducom.com I have been using their components for a while now and have been quite happy with the results. It would certainly prove to be much more straight forward and most likely produce much better performance. Fred > -----Original Message----- > From: Michael Hooker [mailto:[EMAIL PROTECTED] > Sent: Saturday, December 30, 2006 9:22 AM > To: sqlite-users@sqlite.org > Subject: RE: [sqlite] Using sqlite.exe > > > 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] > -------------------------------------------------------------- > --------------- > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
