EAccessViolation whene executing long SQLCommand with TSQLQuery

Article View: borland.public.cppbuilder.database.dbexpress

Article #153

Back to borland.public.cppbuilder.database.dbexpress Previous Next

#153

From: Alper YAZGAN
Date: Tue, 17 Jul 2007 13:24

32 lines
2006 bytes

Is there a sql statement limit when passing SQLCommand thru 
TSQLQuery.Execute() ?
Because I get EAccessViolation during execution of  batches of sql 
statements (mostly inserts) 90K in size ? (And I could execute statements of 
30-40K)

Any comment ?
Thanks,

Alper YAZGAN

PS.
...
  sPointer<TSQLQuery> sqlQuery(new TSQLQuery(NULL));
    sqlQuery->SQLConnection = &sqlConnection;
    sqlQuery->NumericMapping = false;
    sqlQuery->ObjectView = false;
    sqlQuery->GetMetadata = false;
    sqlQuery->ParamCheck = false;
    sqlQuery->Prepared = false;
    sqlQuery->MaxBlobSize = 0;
    try
      {
        sqlConnection->Open();
        sqlQuery->SQL->Text = SQLStatement;  // 90K in size
        sqlQuery->ExecSQL(true);
      }
    catch (Exception &exception)
      {
            // Catches EAccessViolation
      }
...

Technical Details

Message-ID: <469cc35d@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!proxad.net!feeder1-2.proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: fb4e2,b20a52da5150773e,start
X-Google-Thread: f7a32,b20a52da5150773e,start
X-Google-Attributes: gidfb4e2,gidf7a32,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Alper YAZGAN" <alperyazgan@hotmail.com>
Newsgroups: borland.public.cppbuilder.database.dbexpress,borland.public.delphi.database.dbexpress
Subject: EAccessViolation whene executing long SQLCommand with TSQLQuery
Date: Tue, 17 Jul 2007 16:24:52 +0300
Lines: 34
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-Antivirus: avast! (VPS 000757-2, 16.07.2007), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: 212.174.62.11
Message-ID: <469cc35d@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1184678749 212.174.62.11 (17 Jul 2007 06:25:49 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!proxad.net!feeder1-2.proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail