🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: How do i get the plain text returned from SQL server?

#4791
From: Arnie Mauer
Date: Wed, 26 Sep 2001 15:18
33 lines
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!dnews
References: <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