Rich, Thanks for your response... I appreciate your suggested references. The problem is that while I am an expert on some/many things, SQLite and SQL in general is not among them. Nor do I have a strong interest in becoming an expert -- I simply have a simple logging application which has worked fine under Windows Access, but fails under SQLite with an error message which is less than enlightening.
I was hoping to find an interactive blog where experts would enjoy helping newbies with specific suggestions. Thanks again. dave On Sat, Aug 2, 2008 at 10:03 AM, Rich Shepard <[EMAIL PROTECTED]>wrote: > On Fri, 1 Aug 2008, David Nelson wrote: > > > You addressed Dwight's example, but not his question -- which is whether > > there is a resource for answering questions like this. > > dave, > > I thought that my recommendation of Mike Owens' book was a pointer to a > reference that would answer questions such as this. > > Regardless, here's another one: Rick van der Laan's "Introduction to SQL, > 4th Edition." It is an outstanding introduction to DDL (Data Definition > Language; that is, how to design and normalize a database schema) and DML > (Data Manipulation Language; that is, how to enter, retrieve, and alter > data > in tables). > > And for those who want to refine their knowledge and skills, I highly > reccomend any of Joe Celko's books. I read his columns in Data Based > Advisor > in the 1980s and 1990s as well as his books. Last year I had a need to > better understand time-based queries so I wrote to him for pointers to > resources. He recommended Rick's book. > > As an aside, most dbms have datetime data types but do not fully (or even > adequately) support time as presented in the SQL standard. Because most > business (and scientific) databases have a very strong time element > associated with queries and reports this lack surprises me. > > Anyway, Dave, if that's not sufficient, please ask and I'll try to > provide > better answers. > > Rich > > -- > Richard B. Shepard, Ph.D. | Integrity Credibility > Applied Ecosystem Services, Inc. | Innovation > <http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: > 503-667-8863 > _______________________________________________ > 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