[dba-SQLServer]Number of rows affected by update, insert etc

You too?

John W. Colby
www.colbyconsulting.com

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of Arthur
Fuller
Sent: Wednesday, July 23, 2003 4:50 PM
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [dba-SQLServer]Number of rows affected by update, insert
etc


Why am I getting about 6 copies of every message you send, Paul?

Arthur

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of
paul.hartland at fsmail.net
Sent: July 23, 2003 11:57 AM
To: accessd at databaseadvisors.com
Cc: dba-vb at databaseadvisors.com; dba-sqlserver at databaseadvisors.com
Subject: [dba-SQLServer]Number of rows affected by update, insert etc


To all,

I have a VB6 application which uses the dataenvironment to link to a
Access2002 database, and I use command objects connnected to the
dataenvironment which update, delete & insert records.....

Is there anyway I can get the count of how many rows have been affected

Thanks in advance for you help

Paul Hartland

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com