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] -----------------------------------------------------------------------------
