Answer Posted / shyam prasad

Dim Dsn_conn,rs

Set objConnection=Createobject("ADODB.Connection")
Dsn_conn= "DSN=QT_Flight32;DBQ=C:\Program Files\Mercury
Interactive\QuickTest
Professional\samples\flight\app\flight32.mdb;Driver=C:\WINNT
\system32\odbcjt32.dll;DriverId=281;FIL=MS
Access;MaxBufferSize=2048;PageTimeout=5;"
objConnection.Open(Dsn_conn)
Set rs=CreateObject("ADODB.RecordSet")


Set rs=objconnection.execute(" select flight_Number from
Flights where flight_Number>20330") (Instead of this
statement search the table u will get it
)


rs.MoveFirst

While Not rs.EOF
Msgbox rs.fields.item("flight_Number")
rs.movenext
Wend

Is it possible to switch between recording modes during a test creation?

1059

---

How do you compare the structure of 2 tables in database and check whether they are similar using qtp.

1932

---

How to export quicktest professional results to an .xls file?

1177

---

Does quicktest professional is unicode compatible?

957

---

Do you know how to connect database? Can you tell me the procedures?

996

---

What are the different types of action?

992

---

Is it possible to split an action? How?

1115

---

What is the extension of QTP local Repository? If it is .mtr then what is .bdb extension stands for?

1145

---

How to make qtp understand the difference amongst the same type of objects .suppose there are 5 check boxes in a page and I have to choose the 2nd one, how to do that through script?

972

---

Explain how qtp identifies objects?

1017

---

What are the key elements available in test result window?

1194

---

What is difference between shared and local object repository?

1145

---

How to creating an output value using quicktest professional (qtp)?

1020

---

can u explain the keyword driven framework with an example clearly how to create all the files and how to attach to main test.

6214

---

How to use actions in qtp ?

1056

---