i am in the same situation.... simple questions.... for example, i postyed this earlier today:
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) Thanks in advance. On Fri, Aug 1, 2008 at 4:03 PM, Rich Shepard <[EMAIL PROTECTED]>wrote: > On Fri, 1 Aug 2008, Dwight Ingersoll wrote: > > > I have a slew of newbie type questions, ... > > Er, what sort of questions? SQL, specific to SQLite, or something else? > > 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