thanks for your efforts... much appreciated (I'm a C++ developer of many decades, so i know my way around the client code... will keep debugging, must be simple/stupid problem)
On Sat, Aug 2, 2008 at 3:59 PM, P Kishor <[EMAIL PROTECTED]> wrote: > On 8/2/08, David Nelson <[EMAIL PROTECTED]> wrote: > > this is a link to the database > > http://www.savoysoft.com/EvtMgrRequestx05A > > > > > Works fine for me. > > I tried > > SELECT * FROM event WHERE event LIKE '%Vid%'; > > and got a boatload of rows back. > > Has to be something wrong with your compilation. Rest assured, the > problem is not with SQLite or with your db, but with your build of > SQLite or with your program with which you are querying. > > Maybe some Windows folks will be able to help you. > > > > > > > On Sat, Aug 2, 2008 at 3:03 PM, Robert Simpson <[EMAIL PROTECTED] > >wrote: > > > > > > > Can you give us a download link to the database? Does your select > > > statement > > > fail in the sqlite3.exe command-line util? > > > > > > -----Original Message----- > > > From: [EMAIL PROTECTED] > > > [mailto:[EMAIL PROTECTED] On Behalf Of David Nelson > > > Sent: Saturday, August 02, 2008 11:44 AM > > > To: [EMAIL PROTECTED]; General Discussion of SQLite Database > > > Subject: Re: [sqlite] Resources for newbies. > > > > > > OK, P Kishor, here is my problem: > > > > > > Getting "logic error or bad data" when using largw data strings: > > > > > > > > > I create the database as follows: > > > create table Event( Key TEXT[unique], DateTime DATE, Event TEXT, > PRIMARY > > > KEY (Key) ) > > > > > > > > > I add records to the database as follows: > > > insert or replace into Event values( 'strKey', '07/25/2008 > 08:00:00', > > > 'data string' ) > > > > > > And I query the database as follows: > > > SELECT * FROM [Event] WHERE ([Event] LIKE "*foo*" AND [Event] > LIKE > > > "*bar*") AND [Date/Time] BETWEEN DateAdd("n",-5,Now()) AND Now() > > > > > > > > > > > > The query works fine when my inserted data strings are small, like < > 256 > > > bytes. > > > > > > However, I get 'logic error' on the query if my data strings are > largere, > > > like 2048 bytes. > > > > > > > > > Can someone explain what I need to do to support larger data strings? > > > > > > (using C++ under Win/XP and amalgom version of sqlite compiled > directly in > > > the app) > > > > > > > > > > > > > > > On Sat, Aug 2, 2008 at 2:39 PM, P Kishor <[EMAIL PROTECTED]> wrote: > > > > > > > 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 > > > > > > > _______________________________________________ > > > 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 > > > > > -- > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
