How to read expected row from MsAccess table in QTP

[dineshb]

Hi,
Is there any way to get the expected row data of MsAccess Table?
Eg. I want ot read 4th record of MsAcces table ABC.tbl

In WinRunner we use
db_get_row ( session_name, row_index, row_content );

Thanks in advance.
Dinesh

[dineshb]

Hi,
The solution is as below.

Code:

set con = CreateObject("ADODB.Connection")       'Create MsAccess object
set rs =CreateObject("ADODB.recordset")               ' record set
con.provider = "microsoft.jet.oledb.4.0"
Sql = "Select City from Address"  'consider 5 records in table Address
rs.open Sql,con
' moves the control to 2nd record/row by following statement
rs.move(2)

Thanks
Dinesh

[dineshb]

Hi,

One correction :
Please read comment as
' moves the control to 3rd record/row by following statement. The 0 is first record.


Note: I have found this solution by R&D.

Sorry for the trouble.

Thanks
Dinesh