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
SQL Data Source Connection refresh
Re: SQL Data Source Connection refresh
So is the SQL connection suppose to refresh?
- Support Team
- Site Admin
- Posts: 12174
- Joined: Fri Jul 07, 2006 4:30 pm
- Location: Houston, Texas, USA
- Contact:
Re: SQL Data Source Connection refresh
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
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
Re: SQL Data Source Connection refresh
Okay I see it working now in 3.0.3, thanks