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 !!

Iam doing automation in Oracle App's using QTP? In App's because of some functional setup, keep on changing my script flow. for this how can i use the recovery sceanrio?? Please help me?

1 Answers  

It is given in the help of QTP 9.2 that we cant debug the scripts. Is there any other way to VIEW, PAUSE and make modifications in the scripts during execution???

0 Answers  

WHAT IS ETL TESTING.......

2 Answers  

How to capture screen shots when an error occurs?

5 Answers   EDS,

Hi frnds, does anybody know if there is anything called "thin point" or something in qtp? thanks in advance.

1 Answers   scintel,

I want to create Excel object on another machine which is in network i written the code "Set se=createobject ("Excel.Application","\\ankur")"here \\ankur is the name of that machine but i m getting the error of permission denied create object can anybody help me

2 Answers  

What are the views available in quicktest professional (qtp)?

0 Answers  

how do u create new test sets in TD

1 Answers  

-->IF two TextBOxes are there in a "Form". -->A table contains some records which contains usernames & password.. -->What is the script we need to write using Descriptive programming concept...in QTP (simply DATA DRIVEN TEST SCRIPT OF QTP)?

3 Answers   CTS,

What are the views available in quicktest professional?

0 Answers  

How to open any application during Scripting?

3 Answers   Crea,

how to test Web application using QTP software

4 Answers   BITS,