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

How to compare the two strings?

2 Answers  

I want to do Certification course in QTP. For this I request you to suggest the best Tutorial in PDF format, and also tell me the best institute and the estimate cost for joining the institute ib delhi NCR. Hence, if possible, kinldy mail PDF file to my mail-ID: kumar123.pathak@gmail.com , Regards, kumar pathak

0 Answers  

How to make an Action as reusable?

1 Answers  

i've installed qtp9.2 on Windows 7. Recording and everything no problem. But when i am saving the test, it is not happening. it says 'general error while saving'. But teh test is getting saved but as a folder with lock icon. When i wanted to open it, it is jst showing as a locked folder but not as a test. Somebody help me out plz

1 Answers  

I encountered with very strange problem in qtp while writing the script i written the code window"regexpwndclass:=XLMAIN").window"regexpwndtitle:=Open" ).Exit this code was working fine for about 10-15 times i executed the script but after some time qtp started giving the error with the same code the error is "Object doesnt support this method or function window(...).window(..)" then i modified the code with only window"regexpwndtitle:=Open").Exit in place of window"regexpwndclass:=XLMAIN").window"regexpwndtitle:=Open" ).Exit now again its working fine i cannot understand what thing is creating the problem if same code executed successfully in starting for about 10 times then why it is giving the error now can anyone give the reason .

0 Answers  

Please explain me in detail! How to handle runtime errors in QTP useing recovery senario or with out scenario

5 Answers   Quinnox,

scalability testing comes under in which tool?

4 Answers   EpuraTech,

what are the mandatory properties for a tex boxc (scenario?)

0 Answers  

How to create an instance in QTP?

1 Answers   Collabera,

what type of run time errors you get while you ar edoing rpg program?

0 Answers  

What is API?

1 Answers  

1.how can we report the QTP test result in a different excel sheet 2.

3 Answers   Aurigo,