Article View: borland.public.cppbuilder.database.ado
Article #4791Re: How do i get the plain text returned from SQL server?
From: Arnie Mauer
Date: Wed, 26 Sep 2001 15:18
Date: Wed, 26 Sep 2001 15:18
33 lines
1766 bytes
1766 bytes
The TADOQuery has a 'RowsAffected' property that should give you this
information.
- Arnie
"Robert Vozdecky" <admin@vclcomponents.com> wrote in message
news:3bab8185_2@dnews...
> Hi,
> I am using ADO to execute some SQL statement similar to this:
>
> insert into A (A,B) values ('aa','bb')
> insert into A (A,B) values ('aa','bb')
> print ('hello')
> insert into A (A,B) values ('aa','bb')
>
> I want to get the plain text returned by SQL server, which should look
like
> this:
>
> (1 row(s) affected)
> (1 row(s) affected)
> hello
> (1 row(s) affected)
>
> Is there some property or method in ADO which would give me the plain
text?
>
> Thanks for any help.
>
> Robert
>
>
>
Technical Details
Message-ID:
<3bb1f1c3$1_2@dnews>Path:
arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!paloalto-snh1.gtei.net!lsanca1-snf1!news.gtei.net!enterprise!news.xtra.co.nz!newsfeeds.ihug.co.nz!ihug.co.nz!dnewsReferences:
<3bab8185_2@dnews>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: f5cad,2552b6ca53084408 X-Google-Attributes: gidf5cad,public X-Google-Thread: 10698b,2552b6ca53084408 X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2001-09-26 08:29:05 PST From: "Arnie Mauer" <amauer@vrms.com> Newsgroups: borland.public.cppbuilder.database.ado,borland.public.delphi.database.ado References: <3bab8185_2@dnews> Subject: Re: How do i get the plain text returned from SQL server? Date: Wed, 26 Sep 2001 11:18:27 -0400 Lines: 35 Organization: VRMS X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 NNTP-Posting-Host: 209.140.211.97 Message-ID: <3bb1f1c3$1_2@dnews> X-Trace: dnews 1001517507 209.140.211.97 (26 Sep 2001 08:18:27 -0700) Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!paloalto-snh1.gtei.net!lsanca1-snf1!news.gtei.net!enterprise!news.xtra.co.nz!newsfeeds.ihug.co.nz!ihug.co.nz!dnews