How to retrieve the data from database?
Answers were Sorted based on User's Feedback
Answer / haribabu
by using data base checkpoint what ever you want to
retrieve the data
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / kranthi
Hi Hari,
We can Retrieve data from database using datatable or Data
bse checkpoint
Is This Answer Correct ? | 1 Yes | 1 No |
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 |
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 |
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 |
Which version of QTP is using by companies nowadays?
WHAT IS OBJECT REPROSITORY?
In a web site, Protocal has been changed http: to https: what is your approach?
please give me the code for doing retesting of gmail login page using functions so the function has to give the value
what is the default ordinal identifier.what are the send keys in qTP.
Please explain about unicode compatibility in QTP. how we can able to use it. Please help me
what is the test object?
what you mean by artifact,milestone...
Hi, I am new to QTP and vb.script.How to start to write vb.script in QTP? Please give me suggestions?
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
In QTP 8.2 there are lot of check points is this same in latest version QTP 9.5 ?
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