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 Function
Solved! Go to Solution.
According to the MSDN page, RecordsAffected should return the number of affected records.
So, you can try posting its value to the test log:
If this doesn't help, please post here your SQL query.
SmartBear Community and Education Manager