Re: [sqlite] Using sqlite.exe
Sorry I didn't chime in before, but I would strongly recommend using Mike Cariotoglou's mksqlite import library, which is available in the contrib section of the sqlite website. It contains a direct import of the SQLite library into Delphi. I'm using it for a couple of projects right now and it's ideal. The API works identically to the C api, which is quite easy to follow. Mike has also written a Delphi object wrapper which could be of use, although I haven't investigated that. Easy enough to put your own object bindings around the library if you don't like what Mike has done. Contact me off list if you need some help learning the native API. I have a nice example that you can find at Linux Journal by searching on SQLite. Clay Dowling Michael Hooker wrote: > I have sent Ralf a long reply directly. > > No criticism was intended, and eventually I expect to be as impressed by > DiSQLite as I am by SQLiteSpy. It's just that I can't make it work yet and > don't have the time for the steep learning curve. > > Michael Hooker > > -Original Message- > From: Ralf Junker [mailto:[EMAIL PROTECTED] > Sent: 31 December 2006 10:12 > To: sqlite-users@sqlite.org > Subject: RE: [sqlite] Using sqlite.exe > > > Hello Michael Hooker, > >> 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. > > As the author of DISQLite3: The library now contains 17 example projects for > using SQLite with Delphi, even including full text search (FTS1 and FTS2). I > designed them to serve two purposes for both beginners and advanced users: > > * Explain basic and advanced usage of DISQLite3. > * Show the power of SQLite with semi real world applications. > > I agree that the examples use two sets of 3rd party components. I felt they > are necessary to overcome some of Delphi's limitations, most notably the > missing Unicode controls. Both packages (TNT Unicode Controls and > VirtualTrees) are freeware, highly recognized for their outstanding quality > and widely distributed. > > Thanks for letting me know that some aspect of DISQLite3 are apparently > still missing from the demos. Regarding record structures, TStringList and > string arrays: I did not cover these because of their potentially huge > memory requirements. Instead, I demonstrated an intelligent buffering > mechanism. > > However, given the need for it, I will be glad cover these in the demos as > well. What exactly do you want to achieve, and what kind of example project > are you looking for? > >> The documentation is very comprehensive but starts half-way through the >> film, as far as I'm concerned. > > Did you read the chapter labeled "Overview"? Again, if you let me know what > you are looking for I will be glad to add the missing information. > > Ralf > > > > - > 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/610 - Release Date: 30/12/2006 > > -- > No virus found in this outgoing message. > Checked by AVG Free Edition. > Version: 7.1.409 / Virus Database: 268.16.0/610 - Release Date: 30/12/2006 > > > - > To unsubscribe, send email to [EMAIL PROTECTED] > - > -- CeaMuS http://www.ceamus.com Simple Content Management - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] Using sqlite.exe
I have sent Ralf a long reply directly. No criticism was intended, and eventually I expect to be as impressed by DiSQLite as I am by SQLiteSpy. It's just that I can't make it work yet and don't have the time for the steep learning curve. Michael Hooker -Original Message- From: Ralf Junker [mailto:[EMAIL PROTECTED] Sent: 31 December 2006 10:12 To: sqlite-users@sqlite.org Subject: RE: [sqlite] Using sqlite.exe Hello Michael Hooker, >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. As the author of DISQLite3: The library now contains 17 example projects for using SQLite with Delphi, even including full text search (FTS1 and FTS2). I designed them to serve two purposes for both beginners and advanced users: * Explain basic and advanced usage of DISQLite3. * Show the power of SQLite with semi real world applications. I agree that the examples use two sets of 3rd party components. I felt they are necessary to overcome some of Delphi's limitations, most notably the missing Unicode controls. Both packages (TNT Unicode Controls and VirtualTrees) are freeware, highly recognized for their outstanding quality and widely distributed. Thanks for letting me know that some aspect of DISQLite3 are apparently still missing from the demos. Regarding record structures, TStringList and string arrays: I did not cover these because of their potentially huge memory requirements. Instead, I demonstrated an intelligent buffering mechanism. However, given the need for it, I will be glad cover these in the demos as well. What exactly do you want to achieve, and what kind of example project are you looking for? >The documentation is very comprehensive but starts half-way through the >film, as far as I'm concerned. Did you read the chapter labeled "Overview"? Again, if you let me know what you are looking for I will be glad to add the missing information. Ralf - 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/610 - Release Date: 30/12/2006 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.409 / Virus Database: 268.16.0/610 - Release Date: 30/12/2006 - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] Using sqlite.exe
Hello Michael Hooker, >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. As the author of DISQLite3: The library now contains 17 example projects for using SQLite with Delphi, even including full text search (FTS1 and FTS2). I designed them to serve two purposes for both beginners and advanced users: * Explain basic and advanced usage of DISQLite3. * Show the power of SQLite with semi real world applications. I agree that the examples use two sets of 3rd party components. I felt they are necessary to overcome some of Delphi's limitations, most notably the missing Unicode controls. Both packages (TNT Unicode Controls and VirtualTrees) are freeware, highly recognized for their outstanding quality and widely distributed. Thanks for letting me know that some aspect of DISQLite3 are apparently still missing from the demos. Regarding record structures, TStringList and string arrays: I did not cover these because of their potentially huge memory requirements. Instead, I demonstrated an intelligent buffering mechanism. However, given the need for it, I will be glad cover these in the demos as well. What exactly do you want to achieve, and what kind of example project are you looking for? >The documentation is very comprehensive but starts half-way through the >film, as far as I'm concerned. Did you read the chapter labeled "Overview"? Again, if you let me know what you are looking for I will be glad to add the missing information. Ralf - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] Using sqlite.exe
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: sqlite-users@sqlite.org; [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: 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 opened" or > "Database created in directory " - 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 > > > -
RE: [sqlite] Using sqlite.exe
>>because it only would be helpful the first time one uses the sqlite commandline shell.<< No, this is not true. Some of us have very short memories! :) Michael Hooker -Original Message- From: Kees Nuyt [mailto:[EMAIL PROTECTED] Sent: 30 December 2006 17:07 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Using sqlite.exe Hi Michael, On Sat, 30 Dec 2006 15:22:13 -, you wrote: > Thank you Kees - this works! I'm glad it does. >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 opened" or >"Database created in directory " - 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! Though it is a nice suggestion I doubt anyone would care to write the patch, because it only would be helpful the first time one uses the sqlite commandline shell. Once you've set up your development environment, you'll never have to think about it again. If anyone wants to make an effort, just make sure to only output those messages in the same way as the version information: suppress if redirection is active. >Thanks once again - I can get on with my work now! You're welcome, good luck, have fun. >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 > >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 -- ( 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] -
Re: [sqlite] Using sqlite.exe
Hi Michael, On Sat, 30 Dec 2006 15:22:13 -, you wrote: > Thank you Kees - this works! I'm glad it does. >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 opened" or >"Database created in directory " - 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! Though it is a nice suggestion I doubt anyone would care to write the patch, because it only would be helpful the first time one uses the sqlite commandline shell. Once you've set up your development environment, you'll never have to think about it again. If anyone wants to make an effort, just make sure to only output those messages in the same way as the version information: suppress if redirection is active. >Thanks once again - I can get on with my work now! You're welcome, good luck, have fun. >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 > >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 -- ( Kees Nuyt ) c[_] - To unsubscribe, send email to [EMAIL PROTECTED] -
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: 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 opened" or > "Database created in directory " - 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] -
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 opened" or "Database created in directory " - 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] -
RE: [sqlite] Using sqlite.exe
OK, yes, I can see from your post now. Can't think of anything else. RBS -Original Message- From: Michael Hooker [mailto:[EMAIL PROTECTED] Sent: 30 December 2006 14:42 To: sqlite-users@sqlite.org Subject: RE: [sqlite] Using sqlite.exe Yes I know. But the database was definitely made with SQLite3. That's why I asked specifically about SQLite3 databases! Michael Hooker -Original Message- From: RB Smissaert [mailto:[EMAIL PROTECTED] Sent: 30 December 2006 12:22 To: sqlite-users@sqlite.org; [EMAIL PROTECTED] Subject: RE: [sqlite] Using sqlite.exe I think if your database was made with SQLite 2 then you can't open it with SQLite 3. In that case you will need SQLite 2, which I think is still available. RBS -Original Message- From: Michael Hooker [mailto:[EMAIL PROTECTED] Sent: 30 December 2006 11:18 To: sqlite-users@sqlite.org Subject: RE: [sqlite] Using sqlite.exe Thank you. Alas, that is exactly what I thought I should be doing (as the help instructs), but I still get told that the table does not exist, when it does exist. The same happens when I try to open any other table within the database (it's quite a complex one). Are there some types of sqlite3 database which simply won't work with sqlite3.exe, but do work with SQLiteSpy? I have heard on the grapevine that this database will not open in the freeware version of DisqLite 3 but does in the commercial product, so it would seem that there is something odd about it. Michael Hooker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of P Kishor Sent: 30 December 2006 00:47 To: sqlite-users@sqlite.org; [EMAIL PROTECTED] Subject: Re: [sqlite] Using sqlite.exe On 12/29/06, Michael Hooker <[EMAIL PROTECTED]> wrote: > I'm a fairly competent but amateur Delphi programmer and I can construct all > the SQL statements I need. But I'm having enormous trouble making > sqlite.exe work. > > Can some kind person please tell me what, right down to the last > dot and semi-colon, I should type in at the sqlite> prompt to open a SQLite3 > database called "BaseStation.sqb" located in the same folder as sqlite and > then to get a simple SQL query like "select * from Aircraft" to come up with > some data on screen, or preferably save it to a disk file? Whatever I try I > get either a syntax error response or one saying that table Aircraft does > not exist. .. 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. Then you will get a sqlite prompt like so .. SQLite version 3.3.8 Enter ".help" for instructions .. well, go ahead an enter .help (you can also shorten it and enter .h). It will spew out a list of dot commands that you can fool around with. Of course, pure SQL would straightforward like so .. sqlite> select * from Aircraft; .. note that dot commands don't end with a semi-colon, while SQL statements do. This allows you to enter SQL statements on multiple lines like so, if you desire .. sqlite> select ...> * ...> from ...> Aircraft ...> ; Happy SQLiting. -- 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 = -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.409 / Virus Database: 268.15.29/608 - 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 ---
RE: [sqlite] Using sqlite.exe
Yes I know. But the database was definitely made with SQLite3. That's why I asked specifically about SQLite3 databases! Michael Hooker -Original Message- From: RB Smissaert [mailto:[EMAIL PROTECTED] Sent: 30 December 2006 12:22 To: sqlite-users@sqlite.org; [EMAIL PROTECTED] Subject: RE: [sqlite] Using sqlite.exe I think if your database was made with SQLite 2 then you can't open it with SQLite 3. In that case you will need SQLite 2, which I think is still available. RBS -Original Message- From: Michael Hooker [mailto:[EMAIL PROTECTED] Sent: 30 December 2006 11:18 To: sqlite-users@sqlite.org Subject: RE: [sqlite] Using sqlite.exe Thank you. Alas, that is exactly what I thought I should be doing (as the help instructs), but I still get told that the table does not exist, when it does exist. The same happens when I try to open any other table within the database (it's quite a complex one). Are there some types of sqlite3 database which simply won't work with sqlite3.exe, but do work with SQLiteSpy? I have heard on the grapevine that this database will not open in the freeware version of DisqLite 3 but does in the commercial product, so it would seem that there is something odd about it. Michael Hooker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of P Kishor Sent: 30 December 2006 00:47 To: sqlite-users@sqlite.org; [EMAIL PROTECTED] Subject: Re: [sqlite] Using sqlite.exe On 12/29/06, Michael Hooker <[EMAIL PROTECTED]> wrote: > I'm a fairly competent but amateur Delphi programmer and I can construct all > the SQL statements I need. But I'm having enormous trouble making > sqlite.exe work. > > Can some kind person please tell me what, right down to the last > dot and semi-colon, I should type in at the sqlite> prompt to open a SQLite3 > database called "BaseStation.sqb" located in the same folder as sqlite and > then to get a simple SQL query like "select * from Aircraft" to come up with > some data on screen, or preferably save it to a disk file? Whatever I try I > get either a syntax error response or one saying that table Aircraft does > not exist. .. 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. Then you will get a sqlite prompt like so .. SQLite version 3.3.8 Enter ".help" for instructions .. well, go ahead an enter .help (you can also shorten it and enter .h). It will spew out a list of dot commands that you can fool around with. Of course, pure SQL would straightforward like so .. sqlite> select * from Aircraft; .. note that dot commands don't end with a semi-colon, while SQL statements do. This allows you to enter SQL statements on multiple lines like so, if you desire .. sqlite> select ...> * ...> from ...> Aircraft ...> ; Happy SQLiting. -- 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 = -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.409 / Virus Database: 268.15.29/608 - 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] -
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] -
RE: [sqlite] Using sqlite.exe
I think if your database was made with SQLite 2 then you can't open it with SQLite 3. In that case you will need SQLite 2, which I think is still available. RBS -Original Message- From: Michael Hooker [mailto:[EMAIL PROTECTED] Sent: 30 December 2006 11:18 To: sqlite-users@sqlite.org Subject: RE: [sqlite] Using sqlite.exe Thank you. Alas, that is exactly what I thought I should be doing (as the help instructs), but I still get told that the table does not exist, when it does exist. The same happens when I try to open any other table within the database (it's quite a complex one). Are there some types of sqlite3 database which simply won't work with sqlite3.exe, but do work with SQLiteSpy? I have heard on the grapevine that this database will not open in the freeware version of DisqLite 3 but does in the commercial product, so it would seem that there is something odd about it. Michael Hooker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of P Kishor Sent: 30 December 2006 00:47 To: sqlite-users@sqlite.org; [EMAIL PROTECTED] Subject: Re: [sqlite] Using sqlite.exe On 12/29/06, Michael Hooker <[EMAIL PROTECTED]> wrote: > I'm a fairly competent but amateur Delphi programmer and I can construct all > the SQL statements I need. But I'm having enormous trouble making > sqlite.exe work. > > Can some kind person please tell me what, right down to the last > dot and semi-colon, I should type in at the sqlite> prompt to open a SQLite3 > database called "BaseStation.sqb" located in the same folder as sqlite and > then to get a simple SQL query like "select * from Aircraft" to come up with > some data on screen, or preferably save it to a disk file? Whatever I try I > get either a syntax error response or one saying that table Aircraft does > not exist. .. 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. Then you will get a sqlite prompt like so .. SQLite version 3.3.8 Enter ".help" for instructions .. well, go ahead an enter .help (you can also shorten it and enter .h). It will spew out a list of dot commands that you can fool around with. Of course, pure SQL would straightforward like so .. sqlite> select * from Aircraft; .. note that dot commands don't end with a semi-colon, while SQL statements do. This allows you to enter SQL statements on multiple lines like so, if you desire .. sqlite> select ...> * ...> from ...> Aircraft ...> ; Happy SQLiting. -- 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 = -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.409 / Virus Database: 268.15.29/608 - 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] -
RE: [sqlite] Using sqlite.exe
Thank you. Alas, that is exactly what I thought I should be doing (as the help instructs), but I still get told that the table does not exist, when it does exist. The same happens when I try to open any other table within the database (it's quite a complex one). Are there some types of sqlite3 database which simply won't work with sqlite3.exe, but do work with SQLiteSpy? I have heard on the grapevine that this database will not open in the freeware version of DisqLite 3 but does in the commercial product, so it would seem that there is something odd about it. Michael Hooker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of P Kishor Sent: 30 December 2006 00:47 To: sqlite-users@sqlite.org; [EMAIL PROTECTED] Subject: Re: [sqlite] Using sqlite.exe On 12/29/06, Michael Hooker <[EMAIL PROTECTED]> wrote: > I'm a fairly competent but amateur Delphi programmer and I can construct all > the SQL statements I need. But I'm having enormous trouble making > sqlite.exe work. > > Can some kind person please tell me what, right down to the last > dot and semi-colon, I should type in at the sqlite> prompt to open a SQLite3 > database called "BaseStation.sqb" located in the same folder as sqlite and > then to get a simple SQL query like "select * from Aircraft" to come up with > some data on screen, or preferably save it to a disk file? Whatever I try I > get either a syntax error response or one saying that table Aircraft does > not exist. .. 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. Then you will get a sqlite prompt like so .. SQLite version 3.3.8 Enter ".help" for instructions .. well, go ahead an enter .help (you can also shorten it and enter .h). It will spew out a list of dot commands that you can fool around with. Of course, pure SQL would straightforward like so .. sqlite> select * from Aircraft; .. note that dot commands don't end with a semi-colon, while SQL statements do. This allows you to enter SQL statements on multiple lines like so, if you desire .. sqlite> select ...> * ...> from ...> Aircraft ...> ; Happy SQLiting. -- 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 = -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.409 / Virus Database: 268.15.29/608 - 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] -
Re: [sqlite] Using sqlite.exe
On 12/29/06, Michael Hooker <[EMAIL PROTECTED]> wrote: I'm a fairly competent but amateur Delphi programmer and I can construct all the SQL statements I need. But I'm having enormous trouble making sqlite.exe work. Can some kind person please tell me what, right down to the last dot and semi-colon, I should type in at the sqlite> prompt to open a SQLite3 database called "BaseStation.sqb" located in the same folder as sqlite and then to get a simple SQL query like "select * from Aircraft" to come up with some data on screen, or preferably save it to a disk file? Whatever I try I get either a syntax error response or one saying that table Aircraft does not exist. .. 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. Then you will get a sqlite prompt like so .. SQLite version 3.3.8 Enter ".help" for instructions .. well, go ahead an enter .help (you can also shorten it and enter .h). It will spew out a list of dot commands that you can fool around with. Of course, pure SQL would straightforward like so .. sqlite> select * from Aircraft; .. note that dot commands don't end with a semi-colon, while SQL statements do. This allows you to enter SQL statements on multiple lines like so, if you desire .. sqlite> select ...> * ...> from ...> Aircraft ...> ; Happy SQLiting. -- 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] -