Answer / 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

Answer / sesha reddy

plz any one can send answer ,only reading the answers is
not godd friends .plz try to write the answers

from
sesha reddy

Answer / t.sunil kumar

Goto Insert>>checkpoint>>database checkpoint>>wizard will
open >> select the select sql statement manually>> click on
Next>> sepecify the connection string>> enter the query you
want. so that all the data available in the database will
appear in the table format. so that compare the data with
the user interface so that you can find the error in the
database.

plz let me know if there is any wrong in my answer.

Answer / ashok

Using QTP ,and make appropriates db connection and Query to
get a data in Record Set from data base and compare that
data with front end dable to find bugs.

Answer / chandana

Dear Ashok u told the processor ? can u explain me in detail
with steps Plz (chandana)

Answer / ashish srivastava

Hi All,

As per your question i would like to suggest that make sure
that your are passing the same query from the from end as
you are using it in the back-end
as per the question your database having 100 records ,so
make sure that the query ur passing should not have any
"WHERE" AND JOINS statements in the query . If you have then
the Result will be filter and you will get the record
matching to the criteria in the query

FOR USING IT IN QTP PLS write the below code

Dim connect, recset

connect=CreateObject("ADODB.Connection")

recset=CreateObject("ADODB.RecordSet")

connect.Open"Provider=SQLDB1,Userid="Your ID",
Password="Your Password",Database="Your Database"

recset.open "Select Count(*) from your table name",connect

msgbox recset

Answer / lotr

Good reply Sunil. I guess they must have replied if that
solution worked or not !!

Which object repository we use in real time and can we merge 2 object repostiory and how?

3 Answers  

How we can add objects to the object repository during the running?is it possible or not?explain

3 Answers  

3.How to record a word doc using qtp i.e open a word doc,type something and save the doc can someone send me the code.

5 Answers  

Write a code check the checkbox in the web table which is in the 4th row and fifth column (Use child item concept)

2 Answers   FIS, Wipro,

what is the difference between parameters and arguments?

1 Answers  

Hi, I Need code to click the webbutton inside of webtable. I need to click a particular 'Edit' webbutton inside of webtable. For Example... Having 5 Rows and 10 Columns. 'Edit' webbutton are placed in 10th Column. I need to click the 3rd row 'Edit' button with unique value. Browser("....").Page("...").Frame("...").WebButton("btn_Edit ") I Tried with below code: Set objButton = Browser("...").Page("...").Frame("...").WebTable("...").Chil dItem(3,10, Webbutton,0).Click - Not working this code :( Anyone can help me to sort out this simple issue ???

1 Answers  

What is the current version of QTP?

19 Answers  

How QTP integrate with application?

1 Answers  

Hi friend I have query regarding QTP datatable. I want to insert data in datatable during runtime. suppose i wrote datatble.value(1) = "Test data" so when i run the script it says column(1) doesn't exist. Then i write something in column A1 manualy and run the script again. Now it works fine. Pls clarify how i can put value in blank cell of datatable.

10 Answers   Apex,

which type of testing process are you following in ur company? how to recognize a qtp page?

0 Answers  

Tell me the difference between the Data Driven Frame work and Keyword Driven frame work?

3 Answers   Semantic Space,

Explain Descriptive Programming Types with Examples?

0 Answers