Interested to Buy Any Domain ? << Click Here >> for more details...
How to retrieve the data from database?
- 6 Answers
- 12614 Views
- Wipro, I also Faced
- E-Mail Answers
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 |
Why we load add-ins in qtp?
How can I find out whether a word in a string is existed or not for example "QTP IS A POWERFULL TOOL FOR AUTOMATION" How can i find out whether "powerfull" is existed in the above string or not Could anyone answer it?
What is the use of sendkeys.In which cases we Use this sendkey.Pls explain with example.
What will be the script for recovery scenerio.plzanyone give ans with aexample related to banking project
Which function is used to accesses the Properties from Repository Pls anybody can give the answer.. Thanks in advance...
Does QTP support Linux Red Hat? Does QTP support Flash?
1.How do u prepare the test suits in QC? 2.How do u convert requirements to test plan in QC?
when to start the automation?
What is the registration process and examination fees?
Will QTP gets installed on virtual PC.What is the maintenance number to be given
If a object property is changed in the application. where it should be updated in QTP... Pls anybody can give the answer.. Thanks in advance...
What is the another extension name of library file. If that is exist than what's the difference between them.
WinRunner 
