FWIW, there is a second edition of the Definitive Guide to SQLite, apparently coming out in Nov:
http://www.amazon.com/Definitive-Guide-SQLite-Mike-Owens/dp/1430232250/ Allen Grant is the author doing the work. I don't have any details other than that. I hear he's a good guy for the job though. -- Mike On Sun, Sep 12, 2010 at 2:53 PM, Bob Keeland <keela...@yahoo.com> wrote: > Yes, I got an email from Olaf, and I will definitely take any help I can > get. Such help from the VBForum was instrumental in my program for reading > EXIF data from digital photographs. > > Bob > > --- On Sun, 9/12/10, Bart Smissaert <bart.smissa...@gmail.com> wrote: > > > From: Bart Smissaert <bart.smissa...@gmail.com> > Subject: Re: [sqlite] New to SQLite and I have a question > To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> > Date: Sunday, September 12, 2010, 11:28 AM > > > To use SQLite in classic VB or VBA you need this free wrapper: > http://www.thecommon.net/3.html > I have been using it for a few years now (in a commercial application) > and it is fast and easy plus excellent support from the author Olaf > Schmidt. > > RBS > > > On Sat, Sep 11, 2010 at 9:27 PM, Bob Keeland <keela...@yahoo.com> wrote: > > Hi all, > > I am new to using SQLite but think that it may be good for a project that > I'm working on. I do my programming in Visual Basic and don't know any > C\C++. Is there any problem with connecting with SQLite from Visual Basic? > > > > Basically my program will conduct repeatitive searches on a database > based on user input. In most cases the search will be on one variable (one > column) at a time. The database will be relatively small with less than 3000 > records and perhaps a couple hundred columns. For each query of the database > I need to keep the records that match and eliminate all other records. A > followon search will just search the records remaining from the previous > search. Of course I could have the user select several variables and then do > a more thorough search, but for my data that would not work in a lot of > cases. > > > > With enough queries (sometimes just a few and sometimes a lot) the number > of remaining records will approach 1. The one remaining record will contain > the information that the user will be looking for. There will not be any > adding, deleting, or modifying records. This will justy be a tool for > finding information based on variables related to the wanted data. The > database is plant characteristics data and the program will be used by plant > ecologists to determine the species of plant in hand. There are lots of > books that help users do this, but the books use dichotomous keys and the > same thing could be done, in some respects easier, in a program, especially > if the program could eventually be written for a smart phone. I've had good > luck with a similar program on PDAs. > > > > My main question - Does this sound like SQLite would be appropriate? I've > been using Access as my database up to now. If SQLite sounds appropriate can > anyone recommend a good book on SQLite? Any help or suggestions welcome > (even if the answer is go away). > > > > Bob Keeland > > Forest Dynamics, Inc. > > > > > > > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
