ADO Error ?????

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

Article #2878

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

#2878

From: Sarath
Date: Sat, 22 Feb 2003 14:38

26 lines
1500 bytes

 Hi Friends,

        Anybody got an idea how to catch ADO errors.....

eg:

    ADOQuery->Active = false;
    ADOQuery->AQL->Clear();
    ADOQuery->AQL->Add("[Job_Code] Like '*'");
    ADOQuery->Active = true;

    This gave me and error like

"Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT'
or 'UPDATE'"
but after this error message the function getting aborted, I want to catch
this error, and procede to next query is there any way of handling this ?

I tried
    try{
        }
    catch(EDatabaseError &e) //(and EADOError &e also :( )


Thanks in advance
Sarath.

Technical Details

Message-ID: <3e578abb@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!sn-xit-09!supernews.com!news.maxwell.syr.edu!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,d338aaa66b2e6b6a,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-02-22 06:39:02 PST
From: "Sarath" <sarathbs@yahoo.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: ADO Error ?????
Date: Sat, 22 Feb 2003 20:08:50 +0530
Lines: 29
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
NNTP-Posting-Host: 203.195.201.43
Message-ID: <3e578abb@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1045924539 203.195.201.43 (22 Feb 2003 06:35:39 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!sn-xit-09!supernews.com!news.maxwell.syr.edu!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail