Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
GetRows() not fetching the exact record from the recordset
#1
Not Solved
Hi Team,

Im working on validating values between two Database. I'm using GetRows() method to extract the specific rows from the Recordset and the method stores it in a variant as two dimensional array.

This is how Im using that method.
Code:
arrobjrec = firstrecordset.GetRows(Firstrecordset_recordcount)
arrrsobj = secondrecordset.GetRows(secondrecordset_recordcount)
The problem here is, its extracting the speacified record if the count is minimal. eg. if column count is 10 and 320 rows ,
arrobjrec & arrrsobj have 10 subitems, each subitems include [(0,0) to (9,319) ] values the complete recordset or 32 columns and 300 rows its working fine(32 subitems).


However when the column count or row count increases its not retreiving me the exact recordset.

eg: if col - 32 and row count is 350, each tiem when i execute its gives me the wrong count sometimes as 22 subitems(instead of 32 subitems) or 26 subitems. and when i watch the arrobjrec & arrrsobj values, after the 22nd subitem, <qtp_EnumPropertyTimeoutExceeded> in expression and <2s> in corresponding values .

I couldnt able to identify whats the error all about.


Can someone tell me what would be the possible mistake and solution.

Thank you
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Fetching total number of records inside a webtable vidya2k2 2 3,622 06-15-2015, 02:55 PM
Last Post: venkatesh9032
  Fetching values from a web table qapandit 7 8,516 05-30-2014, 02:32 PM
Last Post: nistalaramesh
  Creating an array from an specific field in the recordset Arena 0 2,359 04-04-2012, 09:58 PM
Last Post: Arena
Exclamation Function returns RecordSet TestMe 3 5,270 06-24-2009, 02:02 PM
Last Post: QTPian

Forum Jump:


Users browsing this thread: 1 Guest(s)