Thread Rating:
  • 1 Vote(s) - 1 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Help on how to build checkpoint to compare PB datawindow values row by row
#1
Solved: 11 Years, 4 Months, 4 Weeks ago
Dear all,

Please do help on the captioned subject. Thank you very much.

Here is the sample code with ERROR:
Code:
With PbWindow("PbWin1")
   For i = 1 to .PbDataWindow("dw_list").RowCount
      .PbDataWindow("dw_list").SelectCell i,"id"
      For j = 1 to datatable.GetSheet("ChkList").GetRowCount
         datatable.GetSheet("ChkList").SetCurrentRow(j)
         id=DataTable("id", "ChkList")
         If id = parameter("ID") Then
            datatable.GetSheet("ChkList").SetCurrentRow(j+i-1)
            .PbDataWindow("dw_list").Check CheckPoint("ChkList")
            Exit For
         End If
      Next
   Next
End With

DataTable:
Id Value
1 11
1 22
2 33
3 44
3 55

Actually, I want to validate a PBdatawindow or webtable with 3 rows data. I used the aboved code but don't know how to pass the data row by row to checkpoint since the checkpoint will validate 1 row only at once time.
Reply
#2
Solved: 11 Years, 4 Months, 4 Weeks ago
Hi,

If I have correctly understood you then you want to verify the value of three rows of a WebTable with the value of three rows of the DataTable.

If this is the case, then instead of using checkpoint, I'll suggest you to fetch data from the WebTable by "GetCellData" method and compare it with the value of current row of the DataTable. If it matches then report Pass, if not then report Fail. You can loop it as many time you want to.

If this is not what you want to do, then I beg your pardon.

Please let me know on this..
Reply
#3
Solved: 11 Years, 4 Months, 4 Weeks ago
Dear PrabhatN,

Thank you for your reply. Could you give me some sample code since some columns in my webtable is hidden, it will get run-time error if use your suggested method.

Thank again.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  DataGrid: double click on selected row robertosalemi 0 4,464 05-12-2016, 03:00 PM
Last Post: robertosalemi
  Row count is always shown as 1 Harry1999 0 2,133 04-14-2016, 11:11 PM
Last Post: Harry1999
  Compare WebTable Elements saraiado 1 2,582 06-11-2015, 06:54 PM
Last Post: venkatesh9032
  Keep row number imbizile 0 2,772 09-18-2014, 03:31 AM
Last Post: imbizile
  How to compare two binary values Naresh 0 2,369 09-09-2014, 05:06 PM
Last Post: Naresh

Forum Jump:


Users browsing this thread: 2 Guest(s)