SQL Execution Results

:chuckle:
hi people! In MS SQL Server 8 (query analyzer) when
i execute a query (insert/update/delete) i get the message '2 rows affected'. I wonder how to know how many records have been affected when i execute the query from VB6 using Ado.
Example:


Dim CnDB as New ADODB.Connection
CnDB.Open .....

....
CnDB.Excute "UPDATE Articles SET ArtName='xName' WHERE ArtCod<100;"

Msgbox "5 Records affected!"


Thanks in advanced!!!

i think execute method has a another parameter that you can pass to get the number of rows affected by the process

:)



Dim iaffected As Long

iaffected = 0

'your insert or update statement here
strString = "INSERT INTO myTable SELECT....."

'where cn is your open, active ADO connection

cn.Execute strString, iaffected

'return the number of recs affected

If iaffected > 0 Then
MsgBox "records added: " & iaffected
End If

oh! thanks a lot!!! :)