Re: [sqlite] New to SQLite and I have a question

2010-09-15 Thread Mike Owens
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.

Re: [sqlite] New to SQLite and I have a question

2010-09-12 Thread Bob Keeland
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 wrote: From: Bart Smissaert

Re: [sqlite] New to SQLite and I have a question

2010-09-12 Thread Bob Keeland
Rich,   It is good to hear from another ecologist. You will probably understand my need (desire) to make an electronic plant key. I've had to carry Too Many large and heavy plant keys with me in the field. Something on a PDA or a smart phone would be much easier to carry and probably

Re: [sqlite] New to SQLite and I have a question

2010-09-12 Thread Rich Shepard
On Sun, 12 Sep 2010, Bob Keeland wrote: > Access may not be the best database for my programs, but then again my > needs are not that great. I just need to search a database and then search > the results of the first search, then search the results of the second > search, etc. That sounds simple

Re: [sqlite] New to SQLite and I have a question

2010-09-12 Thread Bart Smissaert
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

Re: [sqlite] New to SQLite and I have a question

2010-09-12 Thread Bob Keeland
Jay, Thanks for the reply. I'll have to reconsider my book purchase. By the way, I love the quote at the bottom of your email. As a professional scientist I've found that when I try to explain what I do most people's eyes tend to glaze over, etc.   My step-son is a computer chip designer. When

Re: [sqlite] New to SQLite and I have a question

2010-09-12 Thread Bob Keeland
Mike,   Thanks for the info. I'll go ahead and get the Mike Owens book to start with. Other books may follow. Yes, I live in Microsoft's world, but not by choice. I worked for the federal government for 25 years and was at the mercy of people higher up on the food chain most of the time. For

Re: [sqlite] New to SQLite and I have a question

2010-09-12 Thread Rich Shepard
On Sat, 11 Sep 2010, Sam Carleton wrote: > If you need to learn the basics of SQL, I would highly recommend the book SQL > For > Smarties. > It covers all the basics and a lot more. I also have his book

Re: [sqlite] New to SQLite and I have a question

2010-09-12 Thread Rich Shepard
On Sat, 11 Sep 2010, Bob Keeland wrote: > While I greatly appreciate the help I've gotten on SQLite in general, I > still wonder about the last part of my questions below. Can anyone > recommend a good book for learning to use SQLite? What about these that I > found on Amazon.com > The

Re: [sqlite] New to SQLite and I have a question

2010-09-11 Thread Jay A. Kreibich
On Sat, Sep 11, 2010 at 06:27:16PM -0700, Bob Keeland scratched on the wall:   > The Definitive Guide to SQLite by Mike Owens Good, but older. Doesn't cover some of the newer features, including many of the _v2() interfaces. Covers SQL and basic database theory. Although this spends

Re: [sqlite] New to SQLite and I have a question

2010-09-11 Thread Sam Carleton
Bob, If you need to learn the basics of SQL, I would highly recommend the book SQL For Smarties. It covers all the basics and a lot more. I also have his book Trees and Hierarchies in SQL for

Re: [sqlite] New to SQLite and I have a question

2010-09-11 Thread Bob Keeland
While I greatly appreciate the help I've gotten on SQLite in general, I still wonder about the last part of my questions below. Can anyone recommend a good book for learning to use SQLite? What about these that I found on Amazon.com   The Definitive Guide to SQLite by Mike Owens Using SQLite by

Re: [sqlite] New to SQLite and I have a question

2010-09-11 Thread Bob Keeland
WOW! I asked for help and it seems that I got a library. Thanks for the information. This will obviously take me some time to study, but it looks like I may be heading in the right direction. Now I just have to come up with the information that will go into the database (whether it would be

Re: [sqlite] New to SQLite and I have a question

2010-09-11 Thread Olaf Schmidt
"Bob Keeland" schrieb > 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? No. Though the links

Re: [sqlite] New to SQLite and I have a question

2010-09-11 Thread Simon Slavin
On 11 Sep 2010, at 9:27pm, Bob Keeland wrote: > 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? You'll need to pick a