Forum Discussion

Berner's avatar
Berner
Occasional Contributor
8 years ago

when I use datadriven test, conn to sql, I just get the last record in the recordset into my request

when I use datadriven testing with connection to sql, I just get the last record in the recordset into my request. I have configure an DataSourceLoop on datasource --> request. Anyone who knows wha...
cunderw's avatar
cunderw
Community Hero

Can you provide more information? Code examples, log messages, how you're connecting, the query, any other relevant information? 

Berner's avatar
Berner
Occasional Contributor
8 years ago

Hi and thanks for a quick answer, I will try to explain more in detail in an attached file.

I have tried a lot of combinations on property transfer and DataSourceLoop but haven´t got any progress, maybe it is some simple thing that I have missed, I dont know.

 

Thanks in advance

 

    • kondasamy's avatar
      kondasamy
      Regular Contributor
      8 years ago

      This post should actually go to Pro community - https://community.smartbear.com/t5/SoapUI-NG/bd-p/SoapUING_forum

       

      Not a problem! Here are few areas which I suspect,

      1) Position of items in Data driven test matters. The working condition is Data Source -> Test Step -> Property Transfer -> Data Source Loop. In you context, the order looks different as Test Step -> Data Source -> Property Transfer -> Data Source Loop. Please runyour test case after changing the positions.

      2) Run from test case level, not from test step level. If you are following this, ignore this comment.

       

      Thanks,

      Kondasamy

       

       

      • Berner's avatar
        Berner
        Occasional Contributor
        8 years ago

        Hi and thanks for quick response

        I changed the order and put the datasource first and then it worked.

         

        Thanks

        Berner