How to return the rows updated when running Updae statement in test complete VB script
When i execute the below function the update statement runs succesfully but it is not throwing how many rows was affected.
Function Sq_QryUdate(field,value )
'Qry1.ConnectionString = "Provider=IBMDA400.DataSource.1;Persist Security Info=False;User ID=XXX;Password=XXX;Data Source=XXX"
Set Qry1 = CreateObject("ADODB.Connection")
Set myCommand = CreateObject("ADODB.Command" )
Qry1.Open = field 'Connection string passed from excel
Set myCommand.ActiveConnection = Qry1
myCommand.CommandText = value' Update statement passed in excel'
myCommand.CommandType = adCmdText
Qry1.Execute value
myCommand.Execute RecordsAffected,adExecuteNoRecords
Log.Message(myCommand.Execute(RecordsAffected,adExecuteNoRecords))
Qry1.Close
End FunctionHi GAutomation,
According to the MSDN page, RecordsAffected should return the number of affected records.
So, you can try posting its value to the test log:
Log.Message(RecordsAffected)
If this doesn't help, please post here your SQL query.
