Interested to Buy Any Domain ? << Click Here >> for more details...
I am verifying the actual vs the input value to make sure
that they been entered correctly. In the Global Sheet I have
a column called Customer with the multiple names in each row
and now I am trying to capture the value during runtime
under the column name Customer_in_Apps.
Somewhat it works but during runtime the values are being
stored in each column vs each row i.e., Customer_in_Apps,
Customer_in_Apps1. Automatically it add columns instead of
rows.
row=datatable.getsheet("Global").GetRowCount
for x=1 to row
datatable.getsheet("Global").SetCurrentRow(x)
Window("Customer Desktop").Window("Customer Tracking
(Privacy").WinObject("TreeView20WndClass").Click 92,244
runtimevalue =
.VbTreeView("vbname:=AppServerTree").GetROProperty("Selectio
n")
Val1=Datatable.Value("Customer",dtGlobalSheet)
Val2 = Datatable.GlobalSheet.AddParameter("Customer_in
_Apps",runtimevalue)
If (trim(Val2)=trim(Val1)) Then
Reporter.ReportEvent micPass, "Customer validation
successful", "Actual Value: " &Val1&vbcrlf& "Customer
Value: " &_Val2
else
Reporter.ReportEvent micFail, "Customer validation
unsuccessful", "Actual Value: " &Val1&vbcrlf& "Customer
Value: " &Val2
End If
Next
- 3 Answers
- 6420 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Hi,
Here the problem is 'AddParameter' used inside the 'FOR'
loop, when QTP runs it successfully add your column
successfully at first time, when the second iteration
perform QTP will check whether the column name is exist
previously or not, if it exist it append numeric, that so u
got N number of column, for that u need use 'AddParameter'
before the loop, below is modified of ur script:
row=datatable.getsheet("Global").GetRowCount
Datatable.GlobalSheet.AddParameter("Customer_in _Apps","")
For x=1 to row
datatable.getsheet("Global").SetCurrentRow(x)
Window("Customer Desktop").Window("Customer Tracking
(Privacy").WinObject("TreeView20WndClass").Click 92,244
runtimevalue =
.VbTreeView("vbname:=AppServerTree").GetROProperty("Selection")
Val1=Datatable.Value("Customer",dtGlobalSheet)
DataTable.Value("Customer_in _Apps",dtGlobalSheet) =
runtimevalue
Val2 = Datatable.GlobalSheet.AddParameter("Customer_in
_Apps",runtimevalue)
If (trim(runtimevalue)=trim(Val1)) Then
Reporter.ReportEvent micPass, "Customer validation
successful", "Actual Value: " &Val1&vbcrlf& "Customer Value:
" & runtimevalue
else
Reporter.ReportEvent micFail, "Customer validation
unsuccessful", "Actual Value: " &Val1&vbcrlf& "Customer
Value: " & runtimevalue
End If
Next
Hope.. it will be usefully for you...
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / pitbull
Based on the above recommendation which I added, but the For is
within a For loop and the scripts run by adding a customer with the
info and then the above for loop comes in place and verify the
customer is added and then it goes back to the first for loop and
add another customer and verify again with the second for loop
above. But when the customer are verified I end up getting the two
columns again.
| Is This Answer Correct ? | 0 Yes | 0 No |
What ever man... don't assign the
'Datatable.GlobalSheet.AddParameter("Customer_in _Apps","")'
line inside the 'FOR' loop, better to write this after the
ur variable declaration part.
| Is This Answer Correct ? | 0 Yes | 0 No |
How do you send email with attachment from outlook using qtp ?
What is Cross browser testing? Does UFT support it?
How do you invoke an application using the step generator in qtp?
is the institute MindQ laid by Mr.Nageswar rao.. heard alot about Nageswar rao...can you briefly let me know about the Nageswar rao inst. and MinQ...THANX IN ADVANCE
In application have 2 list box oppsite list box two edit box is there.so now through using DP how can we select 3 opption in first list box and 2box semect 4 opption.in edit box also we have to write 25 ,28.how can we do this
how do u get lib files into scripting files?
Hi, It is HR question. What are the qualities you like and dislike in your Project Manager?
what is the difference between quality and testing ?
1. I have asked the same question for the third time, but i am getting wrong answers. Pls give me the script to count the number of edit boxes or checkboxes in an windows application screen. In windows application childobject is not working, anyone very urgent
what is Unicode Compatibility ? HOw does this makes a diffrence from Winrunner.?
results.xls file is automatically generated while running the script in QTP.But it is showing error to open the file
how do we know whether all objects are stored in the object repository or not? how can we know if a particular object is not stored in the repository?
WinRunner 
