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, how can we check or avoid the memory leakage in QTP9.2?

0 Answers   Arctern,


What is system testing and what are the different types of tests you perform in system testing?

0 Answers  


How does QTP identifies the object in the application

6 Answers   Convergys,


Hi all, what is the latest version of QTP?

20 Answers   CTS,


Print the Prime numbers in below format only up to 20(Need commas also) 1,2,3,5,7,9,11,13,17,19

0 Answers   Value Labs,


How QTP recognizes Objects in AUT?

1 Answers   Crea,


Do you know how to connect database? Can you tell me the procedures?

0 Answers  


HI. AnyBody can explain Automation Testing Framework...Generally wht do we Intiate before going to start Automation testing process... Anybody can explain.......Thanks in advacne...

1 Answers   HCL,


How to connect to oracle(sqlserver) database to QTP

3 Answers   CTS,


What are the types of environment variables in qtp?

0 Answers  


Is it possible to run qtp scripts in Test Director(Scripts are uploaded in Test director)???and also how to see the test results in test director???

1 Answers  


how can we test load time of an page in webtesting?

3 Answers   Ordain Solutions,


Categories