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 steps involved in recovery scenario wizard?

931

---

What is the syntax to call one script from another?

993

---

What is the Command used to start the QTP

1898

---

Explain different types of action in qtp?

1037

---

could any help me please, how to work on visual foxpro application using UFT

2286

---

what is run-time data?

2140

---

What is system testing and what are the different types of tests you perform in system testing?

1109

---

please post the interview questions for QA position in FACTSET

4395

---

how can we do the frame work in qtp

1986

---

Why to use descriptive programming?

945

---

i have doubt suppose iam purly working in QTP, when i will work on sql and performence testing? pls any one clarify doubt?

1933

---

How do I generate Test Results window using descriptive method ( run time ) after my test execution process? Please have a look of my below code. ========================================================= Dim qtApp Dim qtTest Dim qtResultsOpt Set qtApp = CreateObject("QuickTest.Application") qtApp.Launch qtApp.Visible = True qtApp.Options.Run.CaptureForTestResults = "Always" qtApp.Options.Run.RunMode = "Fast" qtApp.Options.Run.ViewResults = True qtApp.Open "C:\Automation\Example", True Set qtTest = qtApp.Test qtTest.Settings.Run.OnError = "NextStep" Set qtResultsOpt = CreateObject ("QuickTest.RunResultsOptions") qtResultsOpt.ResultsLocation = "C:\Automation\Example\Res1" qtTest.Run qtResultsOpt MsgBox qtTest.LastRunResults.Status qtTest.Close Set qtResultsOpt = Nothing Set qtTest = Nothing Set qtApp = Nothing ========================================================== This code is working fine, but Test Result window is not displaying after execution. Anybody can please help me regading the same. Thanks Akshaya Madali Capgemini India Pvt Ltd 9823213538

4241

---

Name the properties you would use for identifying a browser and page when using descriptive programming?

948

---

Which features or drawbacks of QTP lead to the upgrade for a newer version?

966

---

How to handle dynamic objects in quicktest professional?

896

---