Article View: borland.public.cppbuilder.database.dbexpress
Article #154Re: EAccessViolation whene executing long SQLCommand with TSQLQuery
From: Dave
Date: Tue, 17 Jul 2007 14:55
Date: Tue, 17 Jul 2007 14:55
15 lines
1852 bytes
1852 bytes
"Alper YAZGAN" <alperyazgan@hotmail.com> wrote in message news:469cc35d@newsgroups.borland.com... > Is there a sql statement limit when passing SQLCommand thru > TSQLQuery.Execute() ? I know this is not an answer to your actual question (size limit?), but a seemingly obvious solution would be to break down the 90k SQL into smaller batches if possible. Maybe a bit of a hassle, but if you *know* 30-40k seems to work you can run with that. Through a little experimentation with scaled down batch sizes, you might even be able to get close to the exact size where things stop working. If there is a limit, I would guess it is around 64k. Dave
Technical Details
Message-ID:
<469cd7bf$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nwr.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailReferences:
<469cc35d@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: fb4e2,b20a52da5150773e X-Google-Thread: f7a32,b20a52da5150773e X-Google-Attributes: gidfb4e2,gidf7a32,public,usenet X-Google-Language: ENGLISH,ASCII-7-bit Reply-To: "Dave" <DaytonaDave@dslextreme.com> From: "Dave" <DaytonaDave@dslextreme.com> Newsgroups: borland.public.cppbuilder.database.dbexpress,borland.public.delphi.database.dbexpress References: <469cc35d@newsgroups.borland.com> Subject: Re: EAccessViolation whene executing long SQLCommand with TSQLQuery Date: Tue, 17 Jul 2007 07:55:32 -0700 Lines: 17 Organization: DaytonaDave@dslextreme.com X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2869 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962 X-RFC2646: Format=Flowed; Response NNTP-Posting-Host: 71.177.220.19 Message-ID: <469cd7bf$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1184683967 71.177.220.19 (17 Jul 2007 07:52:47 -0700) Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nwr.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail X-Original-Bytes: 1712