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.
RBS > I've seen some longish SQL queries posted to this list but I was > wondering, how often do 1000+ line queries (as in the SQLite benchmark) > occur in the real world? Do queries of this sort of size exist outside > of initialising tables with a long lists of inserts? > > Martin > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > > > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
