🚀 go-pugleaf

On Fri, 21 Sep 2001 14:06:03 -0400, "Robert Vozdecky"
<admin@vclcomponents.com> wrote:

>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?

To begin with,  I do not believe that you get that plain text results back
from the server as you believe you do.  I suspect that you get back a group
of return codes which the SQL Server client software interprets for you and
displays that information.

If you want to see one way to grab the results from an SQL statement's
execution,  try downloading my TODBC example from Code Central.  This
simple application executes SQL commands and captures the results set
coming back using the ODBC API calls,  and is about the closest that I can
think you will get to what you are asking for.

Jerry Bloomfield (TeamB)
-- 
http://www.teamb.com                                      JersWork@wwa.com
Please do *NOT* send private e-mail without prior permission (my anti-spam 
filters will probably just delete it anyway <g>)