SQL Data Source Connection refresh

Ranorex Spy, Recorder, and Studio.
Pixi6s
Posts: 92
Joined: Tue Jun 28, 2011 8:57 pm

SQL Data Source Connection refresh

Post by Pixi6s » Tue Jun 28, 2011 9:04 pm

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
Posts: 92
Joined: Tue Jun 28, 2011 8:57 pm

Re: SQL Data Source Connection refresh

Post by Pixi6s » Thu Jun 30, 2011 8:29 pm

So is the SQL connection suppose to refresh?

User avatar
Support Team
Site Admin
Site Admin
Posts: 11709
Joined: Fri Jul 07, 2006 4:30 pm
Location: Graz, Austria

Re: SQL Data Source Connection refresh

Post by Support Team » Mon Jul 04, 2011 12:59 pm

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

Pixi6s
Posts: 92
Joined: Tue Jun 28, 2011 8:57 pm

Re: SQL Data Source Connection refresh

Post by Pixi6s » Wed Jul 06, 2011 7:55 pm

Okay I see it working now in 3.0.3, thanks