Answer Posted / saravanaraja

You can Copy & Paste to QTP:

Dim con,rs,ex,a,b,i

Set con=createobject("adodb.connection")
Set rs=createobject("adodb.recordset")
con.open"provider=sqloledb.1;server= ;uid= ;pwd= ;database=
"

rs.open"select count(column name) from table",con

Set ex=createobject("Excel.Application")
Set a=ex.workbooks.open("path of the Excel")
Set b=a.worksheets("sheet1")

i=1

Do while not rs.eof



b.cells(i,1).value=rs.fields("column name")

rs.movenext
i=i+1

loop

What are the different types of recording modes in qtp? Which will be used when?

1050

---

What is the basic concept of quicktest professional?

1039

---

What are the technologies supported by qtp?

960

---

Hi. please provide license key for QTP 9.2, I have windows XP on my machine Thanks in Advance, moreshwar

3240

---

What ate the Technologies supported by QTP?

1143

---

What is the use of text output value in quicktest professional?

972

---

How to record a qtp script ?

1041

---

1.Qtp suppots Unix& linx or not 2why qtp suppots shell script.

2120

---

Write a script to customize the test results in PDF and HTML format.

2542

---

What is throw object?

2366

---

what is the difference between development and testing

3693

---

1.How do u prepare the test suits in QC? 2.How do u convert requirements to test plan in QC?

1952

---

How do you compare the structure of 2 tables in database and check whether they are similar using qtp.

1925

---

Where should i find checkpoint and virtual objects's Object properties and values in the QTP 9.2 Means where checkpoints or virtual objects related data will store If i want to get the runtime object properties how can i use Getroproperties on Checkpoints

1854

---

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

1853

---