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

I hav installed QTP8.2, im working on webapplication, while running the script giving error msg like "QTPro.exe generated errors and will be closed by windows. You will restart the program. An error log is being created". Pls anybody what is the problem, what i have to do for this? Thanks...

2215

---

Is it possible to change the values of analog recording?

1139

---

i have an external excel datasheet where it only contains 3 rows. after qtp executed the code to import the datasheet, the datatable getrowcount method now gives me a different value, lets say 60,000+ instead of only 3. i did not have any values starting from row 4 of my excel file. why is this happening? this also results to the qtp report to load for a very long time.

2026

---

An object is non standard object, i mapped it to standard object, eventhogh on mapping to standard object i cannot use the methods available on the standard object with the mapped object. How i can use those standard object methods with these mapped object. (((Note : dont tell that we can use virtual object as virtual object is to map nonstandard obj to standard obj)))

2138

---

What is difference between Recording time object identification and Run time (Execution) time.

1646

---

what is the difference between the modular framework and datadriven frame work

2481

---

How to execute a winrunner script in quicktest professional (qtp)?

970

---

How to handle dynamic objects in quicktest professional?

950

---

QTP script is not working on other's machine..

1990

---

can anyone tell me what to say in interview when interviewer asks about "tell me about your framework in your project"?

2023

---

Do you know SQL? I know SQL but i don't have any experience...that's it..No more questions ...simply he said " you can leave for the day" ...guys prepare SQL Quires before attending interview in bank of america...

1758

---

Differences between quicktest professional (qtp) and winrunner?

1185

---

This is a question thats generally asked in every QTP interview. What were the problems that you faced during automation and how did you resolve them?

1931

---

How do we handle run-time errors?

1049

---

Why we load add-ins in qtp?

1107

---