On 8/2/08, David Nelson <[EMAIL PROTECTED]> wrote: > 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.
This *is* such an "interactive blog." This is the place where experts and non-experts enjoy helping experts and non-experts with specific and generic suggestions. Just ask, and ye shall be rewarded. > > 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 > -- Puneet Kishor http://punkish.eidesis.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users