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 |
i want click on a link which is in 3rd row and 2nd column of a web table.write script to execute
What is the vb script when the url enter into the browser
in my application,validation message has in japanise language.how to validate this message is appears properly or not
Write a script to verify font style and color of a windows object using descriptive programming
What is the difference between Dim And Redim
4 Answers Hotel Jobs, IBM, Microsoft,
Hi, I'm a beginner in QTP and planning of a certification in QTP, but have no idea about it :P. Could anyone please tell me what certifications that a QTP- beginner can take? What is the fees and the syllabus for the certification? Please reply soon. Thanks Vidhya
How can we disable popup blocker? (I think it means when we get a pop up messge(its error) how we wil disable that one with out interrupting normal process)
What is the use of text output value in quicktest professional?
how to retrieve the xml file data through qtp. can anybody send script for this..
what is the diffrence between script and Language ? (Chandana)
How to Compare two database tables by using QTP?Please give me code details.
What are the enhancements u did after recording ur script?