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
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
Community Manager

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

Hi @Raman,

 

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 September Hub-bub to show off, learn and win
3 REPLIES 3
Super 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(*) ?

Community Manager

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

Hi @Raman,

 

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 September Hub-bub to show off, learn and win
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. 

New Here?
Join us and watch the welcome video:
Watch the New Interview
7Mistakes
Join the September Hub-bub to show off, learn and win