How do you script a nested loop in QTP?
I am showing a snipet of my code. Any suggestions to help
me get this to work would be great appreciated!
STEP A
- Customer Number: No loop
- ISBN: Loop
STEP B
- Customer Number: Loop
- ISBN: Nested Loop
Here is the code I am using now. I am using i for the loop
and j for the nested loop in STEP B of my script.
===========================================
'CREATE AN ADDITIONAL CUSTOMER
Dim myNum, RowNum, RowCnt2, val2, total, i
DataTable.ImportSheet "C:\QOE Data -
UAT1.xls" ,"Data" ,"Global"
RowCnt2 = DataTable.GetRowCount
i = 1
DataTable.SetCurrentRow(i) ' Set row to one
Do while Not i > RowCnt2
i=i+1
DataTable.SetNextRow
MsgBox Datatable.Value("Customer_Num")
Msgbox i
Msgbox RowCnt2
If Not i > RowCnt2 then
val2=datatable.Value("Customer_Num","Global")
OracleFormWindow("Sales Order").SelectMenu "File->New"
OracleFormWindow("Sales Order").OracleTabbedRegion("Order
Information").OracleTextField("Customer Number").SetFocus
OracleFormWindow("Sales Order").OracleTabbedRegion("Order
Information").OracleTextField("Customer Number").Enter val2
End If
'CREATE SECOND ISBN LIST
DataTable.ImportSheet "C:\QOE Data -
UAT1.xls" ,"Data" ,"Global"
Dim j, RowCnt3, val3
RowCnt3 = DataTable.GetRowCount
For j = 1 To RowCnt3
DataTable.SetCurrentRow(i)
' datatable.getSheet("DataTable").setNextRow
If Trim(DataTable("ISBN",dtGlobalSheet)) = "" Then
j = j - 1
Exit For
End If
Next
'Define ISBN rows
If RowCnt3 <> j Then
RowCnt3 = j
End If
'Loop through ISBN rows
For j = 1 To RowCnt3
DataTable.SetCurrentRow(i)
val3 = Datatable.Value("ISBN","Global")
msgbox j
If j = 1 Then
OracleFormWindow("Sales Order").OracleTabbedRegion("Line
Items").OracleTextField("Ordered Item").SetFocus
OracleFormWindow("Sales Order").OracleTabbedRegion("Line
Items").OracleTextField("Ordered Item").Enter val3
else If j < 16 Then
OracleFormWindow("Sales Order").OracleTabbedRegion("Line
Items").OracleTextField("Ordered Item_"&i).SetFocus
OracleFormWindow("Sales Order").OracleTabbedRegion("Line
Items").OracleTextField("Ordered Item_"&i).Enter val3
else If RowCnt1 => 16 Then
OracleFormWindow("Sales Order").OracleTabbedRegion("Line
Items").OracleTextField("Ordered Item_15").SetFocus
OracleFormWindow("Sales Order").OracleTabbedRegion("Line
Items").OracleTextField("Ordered
Item_15").InvokeSoftkey "DOWN"
OracleFormWindow("Sales Order").OracleTabbedRegion("Line
Items").OracleTextField("Ordered Item_15").SetFocus
OracleFormWindow("Sales Order").OracleTabbedRegion("Line
Items").OracleTextField("Ordered Item_15").Enter val3
end if
end if
End If
Next
'EXIT APP
msgbox i
loop
Browser("Browser").Page("Oracle Applications 11i").Sync
Browser("Browser").Close
==========================================
It isn't working correctly in my nested loop in STEP B (for
ISBN).
Any ideas??
Thanks!
SBsteve
No Answer is Posted For this Question
Be the First to Post Answer
Hi, How Accessibility checkpoint in QTP can be implemented in the test script?
How often were they executed?
can any one tell me what is syntax error in line msgexist=Browser("title:=Gmail: Email.*").Page( "title:=Gmail: Email .*").WebElement(innertext=&msg).exist 'code ************** Call login("lal="," " ) wait(5) Call errormsg("Invalid email address. [?]" ) Function errormsg(msg) msgexist=Browser("title:=Gmail: Email.*").Page( "title:=Gmail: Email .*").WebElement(innertext=&msg).exist if msgexist then Reporter.ReportEvent micPass,"enter valid username or pwd ",msg else Reporter.ReportEvent micFail, "entered valid uname and pwd",msg end if End Function
Thanks Rag... One more question, How we test the dynamic images which frequently changed?Using the bitmap checkpoint r any other options available.... Can u give the steps pls... Thanks
HoW to open QTP in Real time.after getting the qtp window how to log in .pl answer real time people
how can we retrieve ten rows from the data table using loop concept?
1. How to capture data from images in QTP and produce them in Excel sheet
write a VBscript code to parametrize test script using test data from sqlserver database?
How to test fly out menu in qtp?
What is the difference between run time object and test object?
If an application name is changes frequently i.e while recording it has name "Window1" and then while running its "Windows2" in this case how does QTP handles?
How can we disable popup blocker? (I think it means when we get a pop up messge(its error) how we wil disable that one with out interrupting normal process)