Issue with UFT Actions

[Murali Dhulipala]

Hi ,

I am trying to parameterize the actions and below is the code which I had designed

Code:

Datatable.ImportSheet "Q:\Excel.xls","Sheet1","Action1" a=datatable.GetSheet("Action1").GetRowCount For i= 1 to a Datatable.GetSheet("Action1").SetCurrentRow(i) If datatable.Value("OracleDatabase","Action1")<>"" Then RunAction Datatable.Value("Scriptname","Action1"), oneIteration,"Oracle" msgbox Datatable.Value("Scriptname","Action1") End If If datatable.Value("SQLdatabase","Action1")<>"" Then RunAction Datatable.Value("Scriptname","Action1"), oneIteration msgbox Datatable.Value("Scriptname","Action1") End If RunAction "Action1 [MediumSanityWF12]", oneIteration Next

and the test data sheet is
Scriptname OracleDatabase SQLdatabase Access
Action1 [GUITest1] Yes Yes
Action1 [GUITest2] YEs Yes


The problem here is, when I was running the above code , for the first iteration "Action1 [GUITest1]" is being executed and it is correct.
In the second iteration, for oracle database,"Action1 [GUITest2]" script executed and for SQL database again "Action1 [GUITest1]" got executed. As per my understanding it should execute "Action1 [GUITest2]" action only as I used the setcurrentrow method of datatable.
I little confused here why it is executing the "Action1" for SQL database instead of "Action2" in the second iteration?

Please make me clear on this.

Thanks,