For loop

[#1]

Hi Friends,

How can we fetch data from different environments(Dev,Test,Prod) by using for loops? It will be very help if any example or document about this

Thank you,

SatishRaj

[Qrishna]

I never tried using for loops for this kind of  scenario, but yes you can write an if() statement something like below.

If Environment = 'PRO' Then

CONNECT TO [....]

Else

CONNECT TO [...]

End If

wrap it up in a text file.rename the extension with .qvs

Include this file in your script.

$(Must_Include=..\_data source\connectionstring.qvs); or $(Include=..\_data source\connectionstring.qvs);

Hope that helps.