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, how can we check or avoid the memory leakage in QTP9.2?
What is system testing and what are the different types of tests you perform in system testing?
How does QTP identifies the object in the application
Hi all, what is the latest version of QTP?
Print the Prime numbers in below format only up to 20(Need commas also) 1,2,3,5,7,9,11,13,17,19
How QTP recognizes Objects in AUT?
Do you know how to connect database? Can you tell me the procedures?
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...
How to connect to oracle(sqlserver) database to QTP
What are the types of environment variables in qtp?
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???
how can we test load time of an page in webtesting?