SQL Execution Results - Xtreme Visual Basic Talk

07-19-2004, 08:04 AM

VeRiTo

Contributor

Join Date: Nov 2003

Location: Buenos Aires

Posts: 614

SQL Execution Results

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:

Code:

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

__________________
.:.VeRiTo.:.

07-19-2004, 08:06 AM

Dennis DVR

Back in the Game

Forum Leader
* Expert *

Join Date: Nov 2003

Location: Manila Philippines

Posts: 3,555

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

__________________
Avatar by Lebb

[Posting Guidelines] [Standards & Practices Tutorial] [Participate here effectively]
Our knowledge can only be finite, while our ignorance must necessarily be infinite. Karl Popper

Last edited by duane; 07-19-2004 at 08:15 AM. Reason: Replace second with another

07-19-2004, 08:18 AM

MKoslof

Cum Grano Salis

Retired Moderator
* Guru *

Join Date: Jul 2002

Location: Baltimore, Maryland

Posts: 14,636

Code:

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

__________________
"Artificial Intelligence is no match for natural stupidity." ~unknown

07-19-2004, 08:25 AM

VeRiTo

Contributor

Join Date: Nov 2003

Location: Buenos Aires

Posts: 614

oh! thanks a lot!!!

__________________
.:.VeRiTo.:.