cancel
Showing results for 
Search instead for 
Did you mean: 

How to return the rows updated when running Updae statement in test complete VB script

SOLVED
Highlighted
Frequent Contributor

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
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Manager

Re: How to return the rows updated when running Updae statement in test complete VB script

Hi @GAutomation,

 

According to the MSDN pageRecordsAffected 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. 

---------
Tanya Gorbunova
SmartBear Community Manager

 Join the virtual SmartBear Connect user conference on April 27-28! Get your free virtual ticket today!

View solution in original post

3 REPLIES 3
Highlighted
Valued Contributor

Re: How to return the rows updated when running Updae statement in test complete VB script

Hi,

Maybe by doing another query before this one with a select count(*) ?

Highlighted
Community Manager

Re: How to return the rows updated when running Updae statement in test complete VB script

Hi @GAutomation,

 

According to the MSDN pageRecordsAffected 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. 

---------
Tanya Gorbunova
SmartBear Community Manager

 Join the virtual SmartBear Connect user conference on April 27-28! Get your free virtual ticket today!

View solution in original post

Highlighted
Frequent Contributor

Re: How to return the rows updated when running Updae statement in test complete VB script

Tanya,

I tried that and it is not returning any values.