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

Which version of QTP is using by companies nowadays?

4 Answers  


WHAT IS OBJECT REPROSITORY?

4 Answers   BirlaSoft,


In a web site, Protocal has been changed http: to https: what is your approach?

2 Answers  


please give me the code for doing retesting of gmail login page using functions so the function has to give the value

0 Answers  


what is the default ordinal identifier.what are the send keys in qTP.

1 Answers  






Please explain about unicode compatibility in QTP. how we can able to use it. Please help me

1 Answers  


what is the test object?

1 Answers  


what you mean by artifact,milestone...

0 Answers  


Hi, I am new to QTP and vb.script.How to start to write vb.script in QTP? Please give me suggestions?

3 Answers  


Hi, I have 2 dropdown listboxes called region and city/area. It needs to select one region(Santa Clara) and one city/Area (Sunnyvale).So I put this in the for loop and I am storing the Items in the variable called itemname. The regions value will get changed,so I used reg expression for this regions. This is my code Browser("MLSListings.com").Page("MLSListings.com").Link("» County/Area").Click Browser("MLSListings.com").Page("MLSListings.com").WebList ("regions").Check CheckPoint("regions") ListSize=Browser("MLSListings.com").Page ("MLSListings.com").WebList("regions").GetTOProperty("items count") For i = 1 To ListSize-1 Itemname =Browser("MLSListings.com").Page ("MLSListings.com").WebList("regions").GetItem(i+1) Browser("MLSListings.com").Page("MLSListings.com").WebList ("regions").Select Itemname ................. If I run the script,I am getting the following error, Cannot identify the specified item of the regions object. Confirm that the specified item is included in the object's item collection. Any Help? Thank you, Uma

0 Answers  


In QTP 8.2 there are lot of check points is this same in latest version QTP 9.5 ?

2 Answers  


Hi All, I am new to QTP but i was trained on winrunner before. My problem is..QTP 8.2 was unable to record my application which is a java app. By selecting smart identification, i was somehow able to record the test BUT QTP cant run the test! Can anyone help me in walking through this problem..Is java addin really necessary for this?? Is there anyways i can run the test successfully? I am not sure whats going wrong in my testing.Please do help me asap as i need to submit the report early. Thanks in advance

4 Answers  


Categories