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 is difference between Recording time object identification and Run time (Execution) time.
Explain the terms test and business component?
How the exception handling can be done using quicktest professional (qtp)?
Why we use QTP ,We can use other tools like WR OrSilktest What r the options in Qtp that WR and Swilktest Does not have.
we add library file used in test via settings or through "ExecuteFile" command. when we implement framework do we make common library file and load the same for all the test cases execution?
we use a file extension .properties why is it used and where do we use it plz help me out with detailed explanation and navigation of how to use on the QTP 8.2?
I am a new tester that needs to create an automatic script involving security questions. On a webpage I need to select a security question(which are random) from a drop down menu, and then input the answer as the last word from the security question. I have the script set-up to automatically select the first security question from the drop down. The problem I am having is trying to insert the security answer. How do I insert the security answer based on the selection from the security question?
How to explain a banking project in interview as a test engineer???
How to use transactions in qtp?
Have you used xml check point in your project?
Hi All, How to get repeated word in string . Thanks Balaji
wht type of User defined functions or Java Releated functions do we write in VB scripting
which type of testing process are you following in ur company? how to recognize a qtp page?
What is data driver in qtp? Where we use it?
How to Get the Run-time value of an object under that web app under Test to the local data table sheet of that Action?