How to handle exception when data table is not available in
local host system or path is not correct(explain statement
with example)
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 This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Hi,All How to create a link in excel sheet using qtp
Why qtp the best testing tool?
How can i get the image text that changes dynamically? Here i have used "GetROProperty", but it's not working. I used like Ex:Browser("webmail").Page("inbox").image ("captchaimage).getroproperty("innertext/text/value")
How do you open adobe acrobat file in QTP and do some testing on that file ?
Any body have QTP 9.5 licence key. please provide me at madhukar_dec30@yahoo.co.in
If I change the object name in one action will it be updated in all the actions? Or not?
How do you send email with attachment from outlook using qtp ?
What is QTP’s model for test creation?
Explain quicktest professional testing process?
What are the views available in quicktest professional?
What is the process of synchronizing qtp and aut?
They asked by using qtp recording writing scripting
Where we can use the analog mode and where we can use the low – level mode?
How will you test a keyboard?
Can any body please tell me the steps of keyword driven framework of QTP.