How to retrieve the data from database?

Answers were Sorted based on User's Feedback



How to retrieve the data from database?..

Answer / haribabu

by using data base checkpoint what ever you want to
retrieve the data

Is This Answer Correct ?    5 Yes 0 No

How to retrieve the data from database?..

Answer / srinu

retrieve the data from the data table

Is This Answer Correct ?    1 Yes 0 No

How to retrieve the data from database?..

Answer / kranthi

Hi Hari,

We can Retrieve data from database using datatable or Data
bse checkpoint

Is This Answer Correct ?    1 Yes 1 No

How to retrieve the data from database?..

Answer / shyam.meghansh

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")

rs.MoveFirst

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


.................Any more question mail me
testingwithshyam@gmail.com

Is This Answer Correct ?    1 Yes 1 No

How to retrieve the data from database?..

Answer / asn

dim con,cmd
set con=createobject("adodb.connection")
set com=createobject("adodb.command")
con.open"provider=sqloledb.1 or ora
oledb.1;server=servername;uid=uid;pwd=password;database=data
sourcename"
cmd.activeconnection
cmd.execute"select*from tablename"

Is This Answer Correct ?    1 Yes 1 No

How to retrieve the data from database?..

Answer / narendra babu

place ur course in data table.
right click on it.select option import data from data base

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More QTP Interview Questions

Hi Friends this is kumar i would like to request to all of you ,please help me to explain real time project with using qtp scripts i know basics of qtp but it won't workout on interviews,pls help awating to reply.

0 Answers   SoftTech,


What is the difference between CVS and VSS? Are you store QTP SCRIPT In VSS OR CVS? Where you store QTP Script?

1 Answers   Brain Roots, Ordain Solutions,


Explain the concept of object repository and how QTP recognizes objects?

0 Answers  


wt is the xtension of the QTP result view file?

4 Answers  


how do you invoke the application through QTP?

1 Answers  






what is the latest version of QTP? Main difference between 9.2 and 10 version

0 Answers  


How can you write the scripts that operate on different objects depending on run-time information?

0 Answers  


What is difference between version 6.5 and 8.2 in QTP?

0 Answers  


what is check point?

2 Answers  


How do you learn the object in QTP?

2 Answers  


Hi Friends, I worked with 8.2 not with 9.2. Please help me in this prob. I created one script and recorded some think and save as Test 1 then I opened process--open the object repository manager. Switch to file->save->give some name->save as Objectrepo1.tsr file. (This is the global repository file.) Then I went to object repository->tools-> associate repository ->click + icon ->open the previously saved Objectrepo1.tsr file. This is the global repository Now I created one more script and save as Test 2. In this script I am calling script with the Help of "Call of existing action" and I executed but QTP is not able to execute B’cos it is QTP is not able to read the Object Repository of Test 1. Please let me know why? Once I made Script 1 as a shared Obj. Repository so it would not give any Problem. Right?

0 Answers   Cap Gemini,


wt is playback facilityin qtp?

2 Answers   IBM,


Categories