SQL Data Source Connection refresh : Automation Tools

[Pixi6s]

Hello,

I am creating a test where I want to connect to a SQL server and with the results from that query run a code set several times. I got the SQL connection setup and working but the data doesn't seem to update/refresh - even when I select the button. I am using the latest Ranorex 3.0.2.

Every time I run this test I will want it to use updated information, I was hoping it would preform the query before each run (after I click play) but worst case, I would want to be able to 'manage' my Data Source and select refresh manually.

How is this behavior suppose to work? I am using a MS SQL DB. I am running on Windows 7.
Thanks

[Pixi6s]

So is the SQL connection suppose to refresh?

[Support Team]

Hi,

the SQL connector performs the query each time before running, but not during the script.
Which means, the data will not be updated before each iteration, but only before the first iteration.

Can you please provide us a detailed description of your workflow.

Regards,
Tobias
Support Team

[Pixi6s]

Okay I see it working now in 3.0.3, thanks