ADODB.Command.Execute | Count of rows affected

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

People,

I need to find out the number of rows affected by a stored proc that I am
invoking using the said method. At the stage I'm in, I cannot use the DAAB,
or even migrate away from using the ADODB to either an OLEDB or ODBC data
connections.

The piece of code that I am using is:

cmd = New ADODB.Connection
With cmd
..ActiveConnection = db 'An open ADODB.Connection object
..CommandType = ADODB.CommandTypeEnum.adCmdText
..CommandText = "{call procXYZ(?)}"
..Parameters.append('a parameter)
End With
cmd.Execute()

At this stage, I need to find out if there were any updates that happened in
the database.
On googling, I came across various approaches that mentioned the usage of 3
optional parameters available in the method. However, I have not been able to
get it working yet.

I am working on ASP.Net with VB as the code behind language.
I would really apprecaiate pointers to solving this. This has made me beat
my head with a hammer!

Thanks in anticipation
Nick
 
well it was primarily because of what the client wanted... i did manage to
find a fix by creating an OUT parameter on the stored proc i was invoking.
Apologies for the late update.

conversion to ADO.net was always on the cards... and work's starting on that
soon.
 
Back
Top