No trouble, I thought that might be the case. I am pleased I finally nailed this down.
RBS -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 08 February 2007 13:14 To: sqlite-users@sqlite.org Subject: RE: [sqlite] x000 line queries - only for benchmarks? No, I just forgot that this all stemmed from the original problem of sqlite_get_table throwing errors. After a while these threads all tend to get a little fuzzy to me. Sorry about that. -- Eric Pankoke Founder / Lead Developer Point Of Light Software http://www.polsoftware.com/ -------------- Original message ---------------------- From: "RB Smissaert" <[EMAIL PROTECTED]> > Yes, VBA supports both, but as it is just for logging purposes my solution > is fine, particularly as these long queries have repetitions of similar > elements. > > Also the function sqlite_get_table will produce an array and the error > happens directly when that function is called, so how is using a collection > or a recordset going to help me? Did you mean alter the C source code? > > RBS > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: 08 February 2007 12:50 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] x000 line queries - only for benchmarks? > > Does VBA support collections? Or you could use an ADO recordset. Either > one should easily let you store elements that are over 2K bytes in length. > > -- > Eric Pankoke > Founder / Lead Developer > Point Of Light Software > http://www.polsoftware.com/ > > -------------- Original message ---------------------- > From: [EMAIL PROTECTED] > > There is no problem running queries of whatever > > length, so I could do benchmarks fine, it is just > > that VBA has a problem with array elements holding > > over 1823 characters. > > > > RBS > > > > > > > [EMAIL PROTECTED] wrote: > > >> In my (commercial) app I regularly have queries with over 1000 > > >> characters. > > >> Not over 1000 lines though. > > >> As VBA (not sure now about VB6) has a problem with > > >> array elements having over 1823 characters I had > > >> to truncate my SQL logging routine. > > >> > > > Under 2k? That seems a bit restrictive. No benchmarking for you then, > > > because the 25k line queries in the SQLite benchmark are nearly 2 meg. I > > > guess they're unusual but even the (more typical?) 100 liners can get up > > > to about 6-8k. > > > > > > Martin > > > > > > > ---------------------------------------------------------------------------- > - > > > To unsubscribe, send email to [EMAIL PROTECTED] > > > > ---------------------------------------------------------------------------- > - > > > > > > > > > > > > > > > > > > > > ---------------------------------------------------------------------------- > - > > To unsubscribe, send email to [EMAIL PROTECTED] > > > ---------------------------------------------------------------------------- > - > > > > > ---------------------------------------------------------------------------- > - > To unsubscribe, send email to [EMAIL PROTECTED] > ---------------------------------------------------------------------------- > - > > > > > ---------------------------------------------------------------------------- - > To unsubscribe, send email to [EMAIL PROTECTED] > ---------------------------------------------------------------------------- - > ---------------------------------------------------------------------------- - To unsubscribe, send email to [EMAIL PROTECTED] ---------------------------------------------------------------------------- - ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
