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