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