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 |
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.
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?
wt is the xtension of the QTP result view file?
how do you invoke the application through QTP?
what is the latest version of QTP? Main difference between 9.2 and 10 version
How can you write the scripts that operate on different objects depending on run-time information?
What is difference between version 6.5 and 8.2 in QTP?
what is check point?
How do you learn the object in QTP?
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?
wt is playback facilityin qtp?