+- 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: How to read specific rows (/Thread-How-to-read-specific-rows)
How to read specific rows - Arena - 04-05-2012
Hi,
I am using an ADO connection to extract my data.
Is it possible to read data ROW by ROW?
I know that rs.GetRows(,,ARRAY(FieldName)) will read the desired column (field).
How can I do that for a specific Row(Record)?
Thanks!
Arena
RE: How to read specific rows - dineshkumar - 04-07-2012
Arena,
You can try filter property like below.
rsRecordSet.Filter = " FirstName = 'Arena' OR FirstName = 'Rose' "
or
rsRecordSet.Filter = " LastName LIKE A* "
Kind regards,
Dinesh