I have made a connection to Access database from QTP using ADODB connection,,,,
and also declared a recordset for it....There are 2 rows in the database and
i want to fetch the values from all the rows...But the problem is that when
all rows are fetched , QTP runs the whole script and again starts for the
first line of the QTP code for the second iteration....and in this process
it again opens the same connection and fetches the same rows again.....
Can anyone tell me how to fetch the values from next of database in the next iteration....
I shall be thankful if anyone can provide me the code for the same ...tx.
I have written following code-
set con = CreateObject("ADODB.Connection")
set rs =CreateObject("ADODB.recordset")
con.provider = "microsoft.jet.oledb.4.0"
con.open "C:\MyFlightDataBase.mdb"
rs.open "select*from flight1",con
row=1
do While not rs.EOF
datatable.SetCurrentRow(row)
datatable.Value (1,1)=rs.fields("FlyFrom")
datatable.Value(2,1)=rs.fields("FlyTo")
datatable.Value(3,1)=rs.fields("Name")
row=row +1
rs.movenext
loop

you are using the Global Sheet..thats resulting in Script Parametrization..

Please use datatable.Value (1,2)

Regards,
Nawab

Hi Nawab,

Will you please elaborate your reply.

Thanx for help

if you check QTP documentation, it specify that global sheet will parametrize the entire script. Hence in your case when ever the data is loaded in Global Sheet i.e datatable("", 1) the script execute the entire code for that row.

now in your case its a DB fetch, hence the script is going in an infinite loop, as your script is fetching certain records and putting them up in Datatable.
(if this portion is not clear please do revert).

hence u are facing unexpected iteration in the execution.

Regards,
Nawab