, I did.
I can't thank you enough.
dave
On Sun, Aug 3, 2008 at 12:40 PM, Hans-Juergen Taenzer <
[EMAIL PROTECTED]> wrote:
> David Nelson ([EMAIL PROTECTED]) wrote:
>
> > Am now thinking there's something wrong with how sqlite gets
> > compiled (using MS Vers 6 Visua
://www.savoysoft.com/log4.txt
Notice that each record grows in size until it gets to 1024 total.
Then, i get errors on the UPDATE.
dave
On Sun, Aug 3, 2008 at 11:06 AM, Alexey Pechnikov <[EMAIL PROTECTED]>wrote:
> Hello!
>
> В сообщении от Sunday 03 August 2008 17:57:33 David Nelson напис
.txt<http://www.savoysoft.com/EvtMgrRequestx05A>
Notice that each record grows in size until it gets to 1024 total.
Then, i get errors on the UPDATE.
dave
On Sun, Aug 3, 2008 at 11:36 AM, David Nelson <[EMAIL PROTECTED]> wrote:
> ok, good idea and easy to do, so i did it...
ok, good idea and easy to do, so i did it
converted CStrings to char szQ[32768]
unfortunately, same problem
On Sun, Aug 3, 2008 at 11:06 AM, Alexey Pechnikov <[EMAIL PROTECTED]>wrote:
> Hello!
>
> В сообщении от Sunday 03 August 2008 17:57:33 David Nelson написал(а):
> &
must be something i said that was confusing... I've been developing
in C++ for over 20 years, programming in general for 45 years!
dave
On Sun, Aug 3, 2008 at 9:41 AM, Alexey Pechnikov <[EMAIL PROTECTED]> wrote:
> Hello!
>
> If you can't write C++ code then write C code. I did send C example
More on 'works only for small strings':
I replaced the sqlite3_exec code with sqlite3_prepare(),
sqlite3_step() and sqlite3_finalize() only to find that it produced
the same 'logic error' [SQLITE_ERROR] in the step() function.
Then, I changed the way I create the record (below) to where I
create
t; [mailto:[EMAIL PROTECTED] On Behalf Of David Nelson
> Sent: Saturday, August 02, 2008 2:00 PM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] Resources for newbies.
>
> here's the create code:
>if( sqlite3_exec( m_pdbData,
>"creat
u're using that's failing?
>
> Also, I'm unclear ... you're calling sqlite3_exec() to select the rows as
> well as insert them?
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of David Nelson
> Sent: Saturday, August 02, 2008 1
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 <[EMA
t;
> -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 Kish
sorry, i use sqlite3_exec(...
On Sat, Aug 2, 2008 at 3:18 PM, D. Richard Hipp <[EMAIL PROTECTED]> wrote:
>
> On Aug 2, 2008, at 3:08 PM, David Nelson wrote:
>
> > i have attached ther database -- only 14k
>
> The mailing list automatically deletes all attachments.
>
, indicating to me that the
problem is with the total size of the record, not the individual column
size.
On Sat, Aug 2, 2008 at 3:08 PM, David Nelson <[EMAIL PROTECTED]> wrote:
> i have attached ther database -- only 14k
>
> and i use sqlite3.exe, not the command line
>
>
> On
mmand-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.
irectly 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 whi
AIL 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'
on a query, I get an error: "logic error or bad database"
it only happens when the record size exceeds 256 bytes.
anyone know what this means?
On Sat, Aug 2, 2008 at 9:03 AM, Alexey Pechnikov <[EMAIL PROTECTED]> wrote:
> Hello!
>
> В сообщении от Saturday 02 August 2008 16:21:44 gerardo
You addressed Dwight's example, but not his question -- which is whether
there is a resource for answering questions like this.
dave nelson
On Fri, Aug 1, 2008 at 6:55 PM, Rich Shepard <[EMAIL PROTECTED]>wrote:
> On Fri, 1 Aug 2008, Dwight Ingersoll wrote:
>
> > SQLite specific. For example,
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
18 matches
Mail list logo