GetRows() not fetching the exact record from the recordset

GetRows() not fetching the exact record from the recordset - Printable Version

+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: VB Scripting/Descriptive Programming (https://www.learnqtp.com/forums/Forum-VB-Scripting-Descriptive-Programming)
+--- Thread: GetRows() not fetching the exact record from the recordset (/Thread-GetRows-not-fetching-the-exact-record-from-the-recordset)

GetRows() not fetching the exact record from the recordset - Saranyaciet2 - 05-27-2015

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