Forum Discussion

GAutomation's avatar
GAutomation
Frequent Contributor
6 years ago

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
  • 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. 

  • m_essaid's avatar
    m_essaid
    Valued Contributor

    Hi,

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

    • TanyaYatskovska's avatar
      TanyaYatskovska
      SmartBear Alumni (Retired)

      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. 

      • GAutomation's avatar
        GAutomation
        Frequent Contributor

        Tanya,

        I tried that and it is not returning any values.