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