Answer / haribabu

by using data base checkpoint what ever you want to
retrieve the data

Answer / srinu

retrieve the data from the data table

Answer / kranthi

Hi Hari,

We can Retrieve data from database using datatable or Data
bse checkpoint

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

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"

Answer / narendra babu

place ur course in data table.
right click on it.select option import data from data base

How to use descriptive programming?

0 Answers  

How can we export test results to an excel sheet in QTP??? Can any one provide sample coding for this?????

6 Answers   TCS,

what is verification & validation?

2 Answers   Accenture, TCS,

what are the attributes of QTP?

3 Answers  

what is Supplemental Objects ?

0 Answers  

Use of Multiple Actions in QTP?

3 Answers  

How u perform exception handling in QTp,what is other name for ths?

2 Answers  

what are the disadvantages of descriptiveprograming

5 Answers   GE,

Can anyone please explain me the process of automating an application using QTP as i am new to this?

1 Answers   Fidelity,

Could you please any one give code for the following ? Scenario : Suppose a excel file contains 10 records and earch have 5 fields. how can i input this excel file for datadrive wizard ? Please explain

0 Answers  

Hi, I want to retrieve the cell data in the WebTable. For that I have defined a new test object under the browser and have given html tag and text as the test object properties. But while I try to identify it it says 'Object description is not unique'. I tried adding innerhtml, outerhtml, innertext and outertext along with the ordinal identifiers; but no use. What more properties need to be added to identify it? Also I want to enable smart identification for this object but the field is disabled in the object repository for this object alone(In QTP tools->object identification the enable smart identification checkbox is enabled). How do I enable it?

3 Answers  

I recorded a Web based Application running on JAVA and when I went to play them back a week later they didn't run. I noticed that the Browser was putting in a (Underscore and a Number) for each line so i re-recorded and noticed the Underscore line wasn't the same as what i recorded last week so any script I record today will not work next week because the browser settings or how QTP recognizes it keeps changing. This is the new line Browser("Bureau of Labor Statistics_4").Page("Bureau of Labor Statistics").JavaApplet("SurveyApplet").JavaList ("Select an Area").Select "U.S. city average" This is the old line 'Browser("Bureau of Labor Statistics_3").Page("Bureau of Labor Statistics").JavaApplet("SurveyApplet").JavaList ("Select an Area").Select "U.S. city average" Notice the Burearu of Labor Statistics_3 adn Burearu of Labor Statistics_4. Why does it change and how do I prevent it from changing.

5 Answers