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


Please Help Members By Posting Answers For Below Questions

Have you done batch testing in qtp? If yes how you are doing?

497


What is the Command used to start the QTP

1524


Where can I find and view run-time data table?

513


What ate the Technologies supported by QTP?

636


Explain the concept of object repository & how qtp recognizes objects?

562






How do you synchronization point through DP?

591


What if recovery scenarios is also failed for identify the alert ? (We are handling unexpected popup through recovery scenarios but if still recovery scenarios also failed than what should be the approach)

1005


What is the extension of the qtp local repository?

555


Hi could some one explan what is the use of the function Defination generator, And how to use the function defination generator.. Explan with the example..

1341


What the differences are and best practical application of Object Repository?

579


How to handle the exceptions using the recovery scenario manager in qtp?

561


what is review

1603


Explain how qtp identifies objects?

558


How many types of parameters are there?

537


Have you used xml check point in your project?

546