🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: SQL error code in ADO?

#2985
From: Emil Doychev
Date: Tue, 14 Jan 2003 14:13
41 lines
2243 bytes
���������� ������,

Thank you very much for your fast and helpful answer. While I waited for an
answer I made a comprehensive lookup in the Microsoft Data Access Components
SDK help at MSDN web site and I was wonder how UNintuitive is decided to put
all errors in the Connection..., but it will work.

Thank you again.

Emil.

"Victor Cazacov" <victor@kazakov.net> wrote in message
news:3e240752@newsgroups.borland.com...
> ������, Emil !
>
>  ED> s.o., but there is no property available for the SQL error code
>  ED> returned by the SQL Server.
>
> TADOConnection::Errors
>
> look at code of my database errors handler:
>
> if ( ADOConnection->Errors->Count )
> {
>     ReportStr+= "Errors Collection:\n";
>     for (i = 0; i < ADOConnection->Errors->Count; i++)
>    {
>       ReportStr+= AnsiString("  Source: ")+
>         ADOConnection->Errors->Item[i]->Source+"\n";
>       ReportStr+= AnsiString("  Native error code: ")+
>         ADOConnection->Errors->Item[i]->NativeError+"  ";
>       ReportStr+= AnsiString("Error number: ")+
>         ADOConnection->Errors->Item[i]->Number+"\n";
>      }
>
> }
>
> --
> Victor
>
>
Technical Details
Message-ID: <3e241b0a@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!64.152.100.70.MISMATCH!sjc70.webusenet.com!c03.atl99!news.webusenet.com!news02.tsnz.net!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail
References: <3e23e7fa@newsgroups.borland.com> <3e240752@newsgroups.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 10698b,3ee6f95cdd2bfba2
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-01-14 06:35:23 PST
From: "Emil Doychev" <isyint@evrocom.net>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3e23e7fa@newsgroups.borland.com> <3e240752@newsgroups.borland.com>
Subject: Re: SQL error code in ADO?
Date: Tue, 14 Jan 2003 16:13:25 +0200
Lines: 43
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 212.116.135.53
Message-ID: <3e241b0a@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1042553610 212.116.135.53 (14 Jan 2003 06:13:30 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!64.152.100.70.MISMATCH!sjc70.webusenet.com!c03.atl99!news.webusenet.com!news02.tsnz.net!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail