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 = "Provide...
  • TanyaYatskovska's avatar
    TanyaYatskovska
    6 years ago

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

m_essaid's avatar
m_essaid
Valued Contributor
6 years ago

Hi,

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

  • TanyaYatskovska's avatar
    TanyaYatskovska
    SmartBear Alumni (Retired)
    6 years ago

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

    • GAutomation's avatar
      GAutomation
      Frequent Contributor
      6 years ago

      Tanya,

      I tried that and it is not returning any values.