Thanks Fred - I need something working by 1 January and don't have time to mess about! I have code already written to feed another command line program which just needs a couple of parameters changed.
I shall try using a Delphi wrapper later on, DiSQLite3 will probably be the one I will choose, but so far I'm struggling to understand the examples because the author has chosen to use a maze of separate units and an unfamiliar set of external third party components to illustrate what it does instead of just showing in a straightforward manner how to get data into a standard Delphi record structure, stringlist, string array or whatever. The documentation is very comprehensive but starts half-way through the film, as far as I'm concerned. Another programmer, far more experienced than I, who is giving me some help with DiSQLite has advised against the AduSoft components because he finds the documentation difficult to understand - so it looks like I wouldn't stand much chance. Which doesn't mean I won't give it a go. In fact, I believe the original commercial software that I'm working with uses the AduSoft components to manage its database - but they've been a bit short-sighted in the reporting facilities provided - for example to get data for any particular day, you have to switch it off and on again every midnight to get data for a 24 hour "session" and then export the data for the particular session. Yet a simple SQLite query will extract data by the date/time it's recorded, whichever session it was recorded in. Michael Hooker -----Original Message----- From: Fred Williams [mailto:[EMAIL PROTECTED] Sent: 30 December 2006 16:01 To: [email protected]; [EMAIL PROTECTED] Subject: RE: [sqlite] Using sqlite.exe 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: [email protected] > 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: [email protected] > 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] ---------------------------------------------------------------------------- - -- 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] -----------------------------------------------------------------------------
