I have an odd request... There is a dynamic table of records in a QTP sheet that is "y" and for each record I am grabbing a value in the row and setting it to SOLN_Qty. Ln 1-4. Then I am trying to move that value assigned to SOLN_Qty to a dynamic WebTable and place it in the first row "z", column 4. However it places that value in all the WebTable rows and I only want the current value of SOLN_Qty in that first WebTable row.
It then proceed to the next y, and assigns SOLN_Qty to whatever the next y rows value is. Then assigns all the WebTable cells, (z,4) to that. and on and on, until the last row of y is reached, and that is the value that each row in the WebTable gets.
Is there a way to tell the second For/Next, or z, to only execute once and not go thru all the rows in the Webtable? We need it to increment z, and go get the next y value, and assign that to the next z. Hope this makes sense. Please advise and thanks.
Actually z and y are equal to the same thing. 3. Unless someone knows of a different way to get the value assigned to SOLN_Qty to the WebTable? Any Idea's?
record_counta = DataTable.GetSheet("SOLNData").GetRowCount
For y = 1 to record_counta 'Goes thru all rows.
SOLN_Qty=Datatable.Value("OrderQty","SOLNData") 'Sets SOLN_Qty to whatever is in row 1
rCount = Browser("SAP NetWeaver Portal").SAPPortal("SAP NetWeaver Portal").Frame("213414_FRAME").WebTable("Number").RowCount 'WebTable row count = same as y
For z = 2 to rCount 'start at row 2, because row one is the headers
'Issue: next line loops through all rows and puts the value of SOLN_Qty in each row of the WebTable, and we only need it in whatever row "z" is. Only need the next line to execute once. Then go get the next y, put it in the next z.
Browser("SAP NetWeaver Portal").SAPPortal("SAP NetWeaver Portal").Frame("213414_FRAME").WebTable("Number").ChildItem(z,4,"WebEdit",index).Set SOLN_Qty