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
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
