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
What are the different types of functions available in qtp and explain ?
What does mean by Scope of Automation?n How we defined it?
How you can replace string in qtp?
Is it possible to call from one action to another action in qtp?
can anyone tell me from where i can download qtp demo or crack version
What is data driver in qtp?
What are the five challenges you faced in QTP?
Hello friends..... On which areas of an application we can not test with QTP
Does quicktest professional is unicode compatible?
Subj: realtime example of Database check point, Can any one please detail on how the Database check point is utilized/implemented in a real time project. I already know how to make one by creating DSN/ODBC and writing the required query manually and other steps...I wanted the actual concept of implementation...couple of live examples will be highly appreciated. Thank you in advance
How to execute a winrunner script in quicktest professional (qtp)?
Some time when i wanna learn the object i face issue like i am not able learn the object in proper manner... eg:for text bo on web page it should learn as webedit but some times it reads as winobject:internetexpoler-server, because of this i have to uninstall the qtp and re-install it again when i do this it reads the object perfectly.....plz suggest the soln
how can we preform retesting(DATA driven test) using function please gine the code for loginpage
what is the difference between data driver & data driven and driver script?
Explain sub procedure of vbscript.